dbcc showcontig

• Zeal-DBA

  SSCarpal Tunnel

  Points: 4332

  More actions

  July 21, 2010 at 6:58 am

  #146303

  hello experts,

  i ran this command :

  DBCC showcontig ('cancandidateresumes')

  and i am getting this result

  - Logical Scan Fragmentation ..................: 80.83%

  - Extent Scan Fragmentation ...................: 94.02%

  can any body explain me wat this result is showing and wat operation i require to do???

  please help

• sql_lock

  SSCrazy Eights

  Points: 9373

  More actions

  July 21, 2010 at 7:09 am

  #1196134

  There is an excellent link that already has the information your require.