Jul 12, 2011

Can SQL Server performance be improved by defragmenting?

Is it possible to speed up the performance of our SQL queries by defragging our database server's RAID?


Possibly, but it's more likely that performance is negatively affected by the database structure, the amount of data that has to be searched, and the server's cpu load (which is in turn affected by the number of users, the amount of RAM, and the number and type of processors in the server).

Answer this