SQL Server Performance

What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Mar 26, 2008.

  1. Anonymous New Member

    Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best way forward to fix the data file fragmentation in SQL Server, say when you have much of SHRINK operations are performed on Database level. The generic answer would be to use the defragmentation tools from windows or operating system based tools, but...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2008/03/26/3722.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3722" width="1" height="1">

Share This Page