August 5, 2002 at 12:54 pm
Our Disk Drives and specifically our SQL Server Database Files are heavilly fragmented. Can we anticipate significant database performance improvements by defragmenting the drives? Are there specific considerations for SQL Server? What experiences have you had?
August 5, 2002 at 1:42 pm
I would expect some improvement, but I'm not sure how significant that will be.
It's not likely that you will have any issues, so it won't hurt.
Steve Jones
August 5, 2002 at 1:46 pm
Its worth doing. The reason the performance benefit is hard to guess is that SQL does some significant caching which hides some disk delays. Even if the pages are contiguous in SQL, they might still be spread across the disk, causing the disk heads to bounce around. Another good reason for doing the drive is that as the mdf/ldf's grow, you want to have a nice area of unfragmented space available for it to grow into.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply