In SQL Server Mangement Studio there are some built-in reports, but they do not cover everything you might want to know about your server, databases, tables, indexes or statistics. In addition to the built-in reports, I will create some useful custom reports for SQL Server 2012, and my 5:th report is the ”Index detail” report. This report will show information about :
- All indexes in the active database
- The key columns in the indexes
- The included columns in the indexes
- Rows in the index
- Pages in the index
- Average number of records / page
- Average size / record
With this report you can see how many indexes you have for each table, how large the indexes are and if you have any duplicated indexes (indexes with the same key columns).
Download SQL Server 2012 Management Studio Report:SQLServiceMonitor_Indexes.zip
I will post all my custom reports at this link : www.sqlservice.se/ssms/custom_reports.aspx
If you have any feature requests, feel free to send me a tweet.