RATE THIS ANSWER
0
Click to Vote:
- 0
0
Last Answered:
May 15 2008 2:05 AM GMT
by Bobkberg
Yes it can, however the benefit will probably be minimal. It will be a great amount of help for a data warehouse, but for OLTP applications the data will be so fragmented throughout the file, that defragmenting the file on the drive will only provide a minimal amount of assistance.
More is gained by making sure that the database file doesn't get fragmented in the first place.
Mr. Denny is quite correct, but the real point is that tuning databases is almost a career in itself. Just doing a search on www.amazon.com searching for "sql server tuning" brought up many matches. Sorry I can't provide any real help - other than to point out that database performance tuning is not an exercise for the faint of heart or inexperienced.
Bob
SQL Server performance tuning, Disk drives, Defragment
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. 
