Missing indexes dashboard
The Missing indexes dashboard contains information about missing indexes in monitored databases:
Each SQL Server contains information through various DMVs about missing indexes. This information is reset when the SQL Server service restarts. Performance Store persists missing indexes information across SQL Server service restarts.
The date_added column shows when Performance Store noticed that the index was missing. 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 missing.
Corresponding view in the Performance Store database:
dbo.v_missing_indexes
Other relevant views in the Performance Store database:
dbo.v_unused_indexes