Will defragmenting hard disks improve SQL Server performance?
Does it help to defragment the local hard disks on SQL Server to improve performance? I just started a new position and the drives on the servers are very fragmented. Could defragmenting them help boost some performance? Thanks.
View Answer
| May 14 2008 3:20 AM GMT
| asked by
SQL Server Ask the Experts
SQL Server performance tuning, Disk drives, Defragment
disk degraded
My as400 is showing a status of 'degraded' when doing a 'wrkdsksts'. I would assume that one of the disk has failed but all say operational when using display hardware resources. Help!
View Answer
| Nov 14 2007 4:22 PM GMT
| asked by
Nosaints
Disk drives, WRKDSKSTS, AS/400
Type of storage/backup solution
Hey everyone,I just started with a medium sized business doing IT work, and they have asked me to research types of backup solutions. At this point we are running a server that holds about 350 GB of data, and we have 2 remote offsite locations which they would also like to back up as well. The...
View Answer
| May 3 2007 3:27 PM GMT
| asked by
DWillms
Storage, Storage products and equipment, Adapters/Interfaces
Please help me…If you know the answer, please put the number and write the answer.
1. The client currently has a A company's dial-up ISP connection, but has just installed B company's broadband as a replacement ? in the month or so it takes to stop the A company's subscription will you be able to:-a. Connect to the A company's POP3 server to receive the A company's emails using...
View Answer
| Feb 1 2007 9:11 AM GMT
| asked by
111110
Exchange, Spam, Exchange security
Data Center Builds
Does anyone have any ideas on how to get involved with build outs for data centers from a telecom perspective. My company is looking for opportunities to build out our network but I need to be able to present them with the scenario. I realize this might sound like a "sales" message or...
View Answer
| Jan 9 2007 4:48 PM GMT
| asked by
lejoneric
Budgeting, Business/IT alignment, Compliance
Exchange 2000 server and ms outlook 2000 installation,configuration
Hi,I am going to deply MS Exchange 2000 server in my organisation, Before that we have no message system, Now we have 200 systems of windows XP/Windows 98 with MS Windows 2000 Advanced Server. Pls guide me how to Install and Configure MS Echange 2000 Server and MS Outlook 2000.What r the parameters...
View Answer
| Jan 8 2007 11:09 PM GMT
| asked by
chinmoymohanty
Exchange security, Hardware, Cabling
Data erasing solutions?
Hello everyone,I am currently working on a worldwide project and I need address one specific issue: Which is the better solution in terms of:1. Administration (time dedicated to daily production).2. Product effectiveness and by this I mean the products capacity to provide a 100% or close to in...
View Answer
| Nov 28 2006 4:25 AM GMT
| asked by
tmachado
Business/IT alignment, Project management, Hardware
Continual CHKDSK errors
I've recently scheduled a daily procedure (CMD) to run on a test group of PCs (including one server with mirrored drives) that runs CHKDSK early every morning. While running under Windows, if it finds errors, it will shutdown/restart and CHKDSK /F will be run to repair the errors. Out of a group...
View Answer
| Oct 20 2006 6:05 AM GMT
| asked by
JWhatley
Hardware, Storage, Disk drives
Increasing server performance
Help reviving servers.Configuration current:8 300GB disks in Raid 5 10000RPM Each.Total 2TB (70%Full) with an average of 68kb files tottal of 24 million files. The curent read rate is at 8MB/Sec on NTFS windows 2003 Partition. Any suggestions on increasing performance on current configuration. P.S....
View Answer
| Sep 7 2006 5:59 PM GMT
| asked by
dimchik
Storage, Storage products and equipment, Adapters/Interfaces
RAID - Upgrading disks to larger ones
Hi all,I wrote not long ago about the best way to upgrade disks when using RAID1.I've now managed to copy all contents from my 2 original volumes, into 2 identical (but larger) volumes on the new larger disk. I used Ghost for this, by making a backup of first the system volume, then the data...
View Answer
| Aug 17 2006 4:38 PM GMT
| asked by
Linger1974
Hardware, Disk drives, RAID
DVD Burner Problem
Hello,I have an issue i never ran into before.I have a brand new CD/DVD burner that will burn CDs but not DVDs.It is a LG GSA-4160B (HL-DT-ST DVDRAM GSA-4160B in windows).Now i already updated the firmware to the latest version (406a) to no prevail.And the strangest thing is if you have a blank DVD...
View Answer
| Jul 10 2006 8:55 PM GMT
| asked by
m4nc1n1
Hardware, Backup & recovery, Disk drives
Disk Usage
I am just looking for opinions about users file server disk usage.About 30% of our users average over 1.25 gig of disk space used. This includes all user files and email file. I am just wondering if this is normal or excessive. If people can please let me know what their usage is I would...
View Answer
| Jul 3 2006 1:19 PM GMT
| asked by
imazing
Budgeting, Business/IT alignment, Project management
End Program - explorer.exe
From the last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes one after another....
View Answer
| Apr 14 2006 7:24 AM GMT
| asked by
BinooDas1234
Data analysis, DataCenter, Database
Report from check disk on active NTFS partition
If I run check disk on the next system boot, I'd like to know if it found and fixed any problems. Does it generate a report, and where would I find it? Someone suggested the event log, but I may not know what I am looking for: a log, a report, a breif line item description?
View Answer
| Mar 27 2006 9:23 PM GMT
| asked by
BullwinkleJMoose
Hardware, Servers, OS
Host based Striping of LUNs
I'm looking for some information regarding host based striping of LUNs - specifically to improve performance. I have a Raid 5 LUN that hold a database. I know that I have a latency issue on this LUN so i'm debating whether to split the LUN into two seperate Raid 5 LUNS then stipe these using host...
View Answer
| Mar 24 2006 6:52 AM GMT
| asked by
geddesb
Storage, Storage products and equipment, Arrays
storage
Hi , I am mahesh.j a fresher , i would like build my carrier on storage .where i am familer to storage hardware now i would like expertise on it.My question is that how to be expertise on it, so i would request u all help me on it by ur guidlines. what are platform of operating...
View Answer
| Mar 21 2006 9:05 AM GMT
| asked by
sjmahesh
Storage, Commvault, Computer Associates
HP EVA 3000 to 6000 upgrade/replacement
HelloCan anyone share with me their experiences or knowledge of upgrading and/or replace a HP Eva 3000 to a HP EVA 6000.Thanks for your time and helpjculkincys
View Answer
| Mar 6 2006 9:59 AM GMT
| asked by
jculkincys
Storage, Storage products and equipment, Arrays
Query on Storage labs
Hi,We are a Software product company exploring options to test our product offerings on EMC, Hitachi storage arrays. Having said this we are looking out for (commercial) Storage labs such as Veritest that enable fee-based access for external users/non-partners.Please have your advice on this.Many...
View Answer
| Mar 1 2006 2:42 AM GMT
| asked by
Mainstream
Storage, Computer Associates, EMC
IBM FC #4319 disk drives
I have 25 4319 10k 35gb disk drives in a closet my management would like to have added to the existing iSeries. My question is if I replace FC#4318 10k 17gb drives with FX#4319 10k 35gb drives will performance degrade?How or where can I find the seek times, MTBF numbers etc to compare performance?
View Answer
| Jan 18 2006 2:03 PM GMT
| asked by
coloskibum
AS/400, Disk drives
Compressing Old Files
Hello,I would like to know the option(Compressing Old Files) which comes up during disk cleanup in win XP and win 2000. Is it good or bad? I mean, If I do the compression regularly will that effect my system/files in a long run? Is it same to that option (compress drive to save space) in disk...
View Answer
| Jan 16 2006 6:37 AM GMT
| asked by
BinooDas1234
Business/IT alignment, Project management, Backup & recovery


