Skip to main content
How can we help?
< All Topics
Print

Indexes dashboard

The Indexes dashboard shows information about indexes in monitored databases, as well as unused indexes:

Each SQL Server contains information through various DMVs about indexes and unused indexes. This information is reset when the SQL Server service restarts. Performance Store persists indexes information across SQL Server service restarts.

The date_added column shows when Performance Store noticed that the index was unused. The post_time column shows when the information was still valid. When the post_time column is no longer being updated with the current time, the index is no longer used.

Corresponding view in the Performance Store database:
dbo.v_indexes

Other relevant views in the Performance Store database:
dbo.v_missing_indexes
dbo.v_hist_table_usage

Table of Contents