A while back I put together a number of posts around an index analysis query that I had put together to assist when I go out to clients. If you are interested, the background for the query can be found in the following posts:
- Analyze Your Indexes Part 1
- Analyze Your Indexes Part 2
- Analyze Your Indexes Part 3
- Analyze Your Indexes Part 4
- Analyze Your Indexes Part 5
- Analyze Your Indexes Part 6
The query has proven to be quite useful for me… one problem with the query, though, was that the format wasn’t the most suitable for quick glance analysis. It gave a lot of useful information but wasn’t in a format that made it easy to digest.
To solve this I’ve put together a report that can be executed from within SQL Server Management Studio.
Please comment and let me know if this is useful or if there are improvements that can help to improve it’s effectiveness.