Show TOC

Index UsageLocate this document in the navigation structure

Use

The Index Usage information is provided by the SQL Server system view sys.dm_db_index_usage_stats. See SQL Server Books Online for more information. The MS SQL Server Index Usage screen can be reached using transaction DBACOCKPIT. Then, the Index Usage screen can be chosen under Performance → Indexes →Index Usage.

Features

The main screen shows a list of SQL Server indexes that have been used a lot based on various criteria. You can enter two pieces of information to provide various views of data:

  • The value to sort by (in descending order). The various fields from sys.dm_db_index_usage_stats can be chosen using a list box.
  • The number of rows selected from the server. Default is 50.

To analyze a given index further you can select the line and choose Table Detail. There you can choose the Runtime Statistics tab to view the index statistics for all indexes of the table.