SQL Server Performance Forum – Threads Archive

DBCC DBREINDEX

I ran DBCC SHOWCONTIG before and after a REINDEX on a table and got back the same results. Here are the results I got back after DBCC DBREINDEX. DBCC SHOWCONTIG scanning ‘TbBIComcCanales’ table…
Table: ‘TbBIComcCanales’ (933578364); index ID: 0, database ID: 7
TABLE level scan performed.
– Pages Scanned…………………………..: 12
– Extents Scanned…………………………: 10
– Extent Switches…………………………: 9
– Avg. Pages per Extent……………………: 1.2
– Scan Density [Best Count:Actual Count]…….: 20.00% [2:10]
– Extent Scan Fragmentation ……………….: 90.00%
– Avg. Bytes Free per Page…………………: 3058.9
– Avg. Page Density (full)…………………: 62.21%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Is there something IÂ´m missing please help. Cheers!

I gess, because index ID 0, this is the table insef.
And wath you see is Scand dentity of the table, no specific index. If I’m not wrong only way to defrag tables is drop and create again.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

How many records are in the table, and how large is each row? Are most of the columns in the table fixed length, or variable length? —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

I had also ran DBCC DBREINDEX(INDEX NAME) and low scan density results. DBCC DBREINDEX (tbbicomcCanales,PK_TbBIComcCanales,70) DBCC SHOWCONTIG (tbbicomcCanales, PK_TbBIComcCanales)
DBCC SHOWCONTIG scanning ‘TbBIComcCanales’ table…
Table: ‘TbBIComcCanales’ (933578364); index ID: 2, database ID: 7
LEAF level scan performed.
– Pages Scanned…………………………..: 3
– Extents Scanned…………………………: 3
– Extent Switches…………………………: 2
– Avg. Pages per Extent……………………: 1.0
– Scan Density [Best Count:Actual Count]…….: 33.33% [1:3]
– Logical Scan Fragmentation ………………: 0.00%
– Extent Scan Fragmentation ……………….: 33.33%
– Avg. Bytes Free per Page…………………: 3111.0
– Avg. Page Density (full)…………………: 61.56%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
So Luis, what you conclude is that the best method to defrag is to use CREATE INDEX and WITH DROP_EXISTING on the clustered indexes? Cheers!

After read Brad post, check
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2520 I think there is same discusion.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

In reply to brads questions… This perticular table has 10356 records, row size I’ll have to check on, there are no fixed length columns. I am just using on table as an example, but there are many tables with same results. Cheers!

]]>