Post reply

Dbcc showcontig

  • April 24, 2006 at 9:33 am

    #117397

    I ran Dbcc showcontig against one of my tables and i got following  results

    DBCC SHOWCONTIG scanning 'Webhits' table...

    Table: 'NOTES' (581577110); index ID: 1, database ID: 18

    TABLE level scan performed.

    - Pages Scanned................................: 551860

    - Extents Scanned..............................: 69430

    - Extent Switches..............................: 226910

    - Avg. Pages per Extent........................: 7.9

    - Scan Density [Best Count:Actual Count].......: 30.40% [68983:226911]

    - Logical Scan Fragmentation ..................: 16.68%

    - Extent Scan Fragmentation ...................: 37.41%

    - Avg. Bytes Free per Page.....................: 2465.8

    - Avg. Page Density (full).....................: 69.53%

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    After Reindexing  with fill factor 70( this table as lot of inserts and as well Select also), i got following results.

    DBCC SHOWCONTIG scanning 'Webhit' table...

    Table: 'NOTES' (581577110); index ID: 1, database ID: 18

    TABLE level scan performed.

    - Pages Scanned................................: 541914

    - Extents Scanned..............................: 68016

    - Extent Switches..............................: 68015

    - Avg. Pages per Extent........................: 8.0

    - Scan Density [Best Count:Actual Count].......: 99.59% [67740:68016]

    - Logical Scan Fragmentation ..................: 0.00%

    - Extent Scan Fragmentation ...................: 31.57%

    - Avg. Bytes Free per Page.....................: 2362.5

    - Avg. Page Density (full).....................: 70.81%

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

     

    everything looking good but still Extent Scan Fragmentation ...................: 31.57%

    how we can reduce Extent Scan Fragmentation ?

    Please somebody help me.

     

     

  • April 24, 2006 at 9:39 am

    #633831

    hi,

    look in Book s Online (BOL) for DBCC DBREINDEX. This should help.

    Paul

  • April 24, 2006 at 11:28 am

    #633869

    After reindex only i got above results. but still Extent Scan Fragmentation ...................: 31.57%

     

  • April 24, 2006 at 11:59 am

    #633874

    Have you tried dropping the index and re-creating it? I don't know if that will do it but it's something to try.

    Regards,

    Mark

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply