Checking health of sql (2000) tables and their index history

• Prasanna Sridharan

  Valued Member

  Points: 51

  More actions

  December 4, 2007 at 6:24 am

  #127217

  I want to check the health of the any table in the database (like is it indexed completely or the index run on it was long ago, also when was the last indexing done on this table) and how fragmented is the table data etc.

  Is there any query to do that or can enterprise manager be used to check this..

  Thanks,

  Prasanna

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  December 4, 2007 at 7:36 am

  #756935

  1) Use DBCC CHECKTABLE to check the health of the table.

  2) Use DBCC SHOWCONTIG to check the index fragmentation.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736627

  More actions

  December 4, 2007 at 9:08 am

  #757010

  Indexes are updated automatically as data changes. You do not need to do anything here.

  You should have auto-update statistics on.

  Run dbcc checkdb (includes checktable) at least weekly to look for linkage or other errors.