Post reply

To Know fragmentation?

  • December 9, 2008 at 10:36 am

    #77152

    DBCC SHOWCONTIG scanning 'KOC' table...

    Table: 'KOC' (2555657638); index ID: 1, database ID: 11

    TABLE level scan performed.

    - Pages Scanned................................: 679

    - Extents Scanned..............................: 99

    - Extent Switches..............................: 105

    - Avg. Pages per Extent........................: 7.3

    - Scan Density [Best Count:Actual Count].......: 77.36% [82:106]

    - Logical Scan Fragmentation ..................: 2.31%

    - Extent Scan Fragmentation ...................: 28.09%

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

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

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

    In above results which one exactly tells that there is a fragmentation?

  • December 9, 2008 at 11:10 am

    #909824

    kotlas7 (12/9/2008)

    - Logical Scan Fragmentation ..................: 2.31%

    For an index, that's the most important one. Extent fragmentation is less important but should still be kept low.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

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