This blog is part of the blog series named SQL Server Monitoring.
Purpose
To get a list of how the tables and indexes are configured, if they are heap or clustered, are they primary key, unique, filtered, …
The report shows the number of rows per table if the report is not drilled down to the index level, but if drilled down to the index level it is the number of rows pr. index that are shown, and this will be different to the number of rows in the table if the index is filtered.
Sources
This feature queries the DMV sys.indexes which returns information about the configuration of the indexes.
Report
The report has a table matrix showing all indexes and their configuration.
Model
The model for the report uses the fact [Index configuration] and the dimensions [Index], [Table type] and [Object].
As a auxiliary fact [Table size] is used to provide information about number of rows and data and index size usage.
Configuration
The report uses the same data as used by the Index usage report.
