SQL Server Performance Forum – Threads Archive
dbcc showcontigHello DBA’s I just wanted to know what might be the healthy signs of a database when you run dbcc showcontig to make sure it is free of fragmentation.
I know that we have to look for figures like the following, but I wanted to know what figure of these will indicate a healthy d/b Scan Density [Best Count:Actual Count
Logical Scan Fragmentation
Extent Scan Fragmentation Thanks
Read the following article …
Microsoft SQL Server 2000 Index Defragmentation Best Practices
Mohammed That was helpful very much
http://www.sql-server-performance.com/dt_dbcc_showcontig.asp Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.