DBCC SHOWCONTIG

• bang725

  Mr or Mrs. 500

  Points: 577

  More actions

  November 3, 2008 at 10:43 am

  #195326

  can somebody tell me about below results ?

  DBCC SHOWCONTIG scanning 'Universal' table...

  Table: 'Universal' (149575571); index ID: 1, database ID: 5

  TABLE level scan performed.

  - Pages Scanned................................: 2844126

  - Extents Scanned..............................: 361422

  - Extent Switches..............................: 497852

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

  - Scan Density [Best Count:Actual Count].......: 71.41% [355516:497853]

  - Logical Scan Fragmentation ..................: 1.63%

  - Extent Scan Fragmentation ...................: 9.63%

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

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

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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 3, 2008 at 1:31 pm

  #893241

  Your index is very, very slightly fragmented (logical scan fragmentation. Lower is better) and the pages are 90% full (Avg. Page Density. Close to 100% is usually better)

  All in all, the index looks in good shape.

  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

• SQL_DBA_3

  SSCarpal Tunnel

  Points: 4772

  More actions

  November 3, 2008 at 1:41 pm

  #893248

  Scan density is low .It should be closer to 100%.Index rebuild is required once.The pages scanned will be decreased and thus your scan density increases.Fragmentation is good(less than 20% is always preferred).