Posted by rshivaraman on 05/04/07 13:27

DBCC SHOWCONTIG (TableA)-- 18:39 minutes

DBCC SHOWCONTIG scanning 'TableA' table...
Table: 'TableA' (549576996); index ID: 0, database ID: 15
TABLE level scan performed.
- Pages Scanned................................: 6007257
- Extents Scanned..............................: 750994
- Extent Switches..............................: 750993
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.99%
[750908:750994]
- Extent Scan Fragmentation ...................: 21.20%
- Avg. Bytes Free per Page.....................: 368.0
- Avg. Page Density (full).....................: 95.45%
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.



exec SP_SPACEUSED TableA

name rows reserved data
index_size unused
tbl06521AA 504609530 125679832 KB 48058056 KB 77594288 KB 27488 KB

• Next in forum: DTS Job Reporting Failures
• Prev in forum: Re: Need to tune a table for performance gains
• Thread view: Re: Need to tune a table for performance gains

[Reply to this message]