SQL Server is running with data and logs on Raid1+0 Disk Drive.I analyzed the harddisk for fragmentation and I see file fragmentation 95%, Total Fragmentation 47%. Running update on a table, after joining tables with over 8 million records shows Average Disk Queue length is over 100. Should I use disk defragmenter Windows 2003 tool to defragment the drive. What is long term and short term solution? I have these findings/assumptions: Its not out of RAM because buffer hit cache ratio is 99+%. It is not utilizing lot of CPU because %Processor time is very low. there is no old statistics and internal fragmentation on indexes: because DBCC DBREINDEX builds the index and updates the statistics and I recently ran DBCC DBREINDEX with 90% fill factor. The first bullet point after 3rd paragraph also seems to advice that disk deframentation is required before index defragmentation. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx wanted some expert opinions before I perform this operation on production server.