SQL Server Performance

dbcc showcontig information

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by xponcall, Aug 30, 2007.

  1. xponcall New Member

    I ran the showcontig on the table and with the result below. What does it means when Extent Scan Fragmentation is high?
    Could I do anything to improve the table performance?

    thanks
    DBCC SHOWCONTIG scanning 'table' table...
    Table: 'table' (1435152158); index ID: 0, database ID: 5
    TABLE level scan performed.
    - Pages Scanned................................: 454
    - Extents Scanned..............................: 60
    - Extent Switches..............................: 59
    - Avg. Pages per Extent........................: 7.6
    - Scan Density [Best Count:Actual Count].......: 95.00% [57:60]
    - Extent Scan Fragmentation ...................: 88.33%
    - Avg. Bytes Free per Page.....................: 299.9
    - Avg. Page Density (full).....................: 96.30%


  2. satya Moderator

Share This Page