SQL Server Performance Forum – Threads Archive

dbcc showcontig

Hello 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
Satya

---

Read the following article …
Microsoft SQL Server 2000 Index Defragmentation Best Practices
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
MohammedU.
Moderator
SQL-Server-Performance.com

---

Mohammed That was helpful very much
Satya

---

http://www.sql-server-performance.com/dt_dbcc_showcontig.asp Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
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.

---

]]>