Can SQL server performance improved by defragmenting ?

Asked By 40 points N/A Posted on -
qa-featured

The drives on my SQL Server are fragmented & I assume because of this, I have a slow performance on my SQL Server.

I want to defragment my drives. Can anybody let me know, whether defragment will help to boost the SQL Server's performance ?

SHARE
Answered By 0 points N/A #114065

Can SQL server performance improved by defragmenting ?

qa-featured

Hello Sushmita,

It sounds like you are referring to the OS level defragmentation. Yes, it is of great help. The files used by SQL server when defragmented will become more contiguous on disk. But you might also consider SQL server level of defragmentation. To check if you have fragmented table data, use this Transact -SQL command: sys.dm_db_index_physical_stats if you are using SQL Server 2008. (Older SQL server version was DBCC SHOWCONTIG command). This command will report to you size and fragmentation information of your database data and indexes.

If you think you need to defrag the index use ALTER INDEX command. (Older SQL version was DBCC INDEXDEFRAG). This command will help improve index scanning performance. Doing both OS level defragmentation and SQL Server level defragmentation will surely boost your SQL server's performance.

Related Questions