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. 

If you are interested in this report, there is now a CodePlex project for the query and the custom report.  And it is aptly named IndexAnalysis.

Please comment and let me know if this is useful or if there are improvements that can help to improve it’s effectiveness.