Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Issues with DBCC SHOWCONTIG

Author  Topic  gordonp Starting Member 1 Post Posted - 2005-02-18 : 07:49:03 I am trying to resolve database fragmentation and I am having two issues with the DBCC SHOWCONTIG command. 1. Running DBCC SHOWCONTIG WITH FAST, ALL_INDEXES, TABLERESULTS shows different values for logical fragmentation then running DBCC SHOWCONTIG(<tablename>) WITH FAST, ALL_INDEXES, TABLERESULTS. Which value should be considered as correct? 2. For some tables DBCC SHOWCONTIG(<tablename>) WITH FAST, ALL_INDEXES, TABLERESULTS shows results for indexes that do not appear in the QA Object Browser or the EM Manage Indexes/Relationship window. Consequently, running DBCC INDEXDEFRAG on those indexes results in an error on Parameter 3, the index name. What is going on here? BONUS QUESTION: 1. Which is a more accurate reflection of fragmentation: Logical Fragmentation or Scan Density?