October 8, 2007 at 11:09 am
I have a table in SQL Server 2005 DB which has about 650 million records. When I run a DBCC showcontig on it, I get 0 for all storage parameters and 100% for scan density. Please see the output below.
[font="System"]DBCC SHOWCONTIG scanning 'MyLargeTable' table...
Table: 'MyLargeTable' (724913654); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 0
- Extents Scanned..............................: 0
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 0.0
- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 0.0
- Avg. Page Density (full).....................: 0.00%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.[/font]
Any idea what could be causing this? I recently built this table with another name and then renamed the table to its current name. The table is partitioned and has a clustered primary key.
I have tried rebuilding the index, running dbcc freeproccahe and updating statistics on the table, but none of these have worked.
Regards
Rupendra
October 8, 2007 at 4:44 pm
There is one pesky problem DBCC SHOWCONTIG is obsolete in 2005 you use sys.dm_db_index_physical_stats instead try the link below for details. Why the indexes are owned by the ANSI SQL manufacturers like Microsoft so in 2005 most things you know about indexes in 2000 was replaced. Hope this helps.
http://msdn2.microsoft.com/en-us/library/ms188917.aspx
Kind regards,
Gift Peddie
October 9, 2007 at 11:43 am
Thanks, that helped a lot.
Regards
Rupendra
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply