Show TOC

Index Operational StatisticsLocate this document in the navigation structure

Use

The Index Operational Statistics information is provided by the SQL Server system view sys.dm_db_index_operational_stats. For more information, see SQL Server Books Online.

You can reach the MS SQL Server Index Operational Statistics screen with transaction DBACOCKPIT. Then, you can choose the Index Operational Statistics screen under Performance → Indexes → Index Operational Statistics.

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.

    You can select the dm_db_index_operational_stats 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.