sys.dm_db_index_usage_stats

• repent_kog_is_near

  SSCertifiable

  Points: 7278

  More actions

  March 25, 2010 at 2:39 am

  #218492

  Is this DMV populated for all the indexes for all the databases? or does it get filled as indexes are being used?

  Dan

• LythamsFinest

  SSCommitted

  Points: 1786

  More actions

  March 25, 2010 at 2:49 am

  #1139456

  Entries only appear in the DMV after the index is used for the first time.

• Paul White

  SSC Guru

  Points: 150468

  More actions

  March 25, 2010 at 4:08 am

  #1139485

  Full details in Books Online:

  sys.dm_db_index_usage_stats

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi