Attached at the end of this post is a set of NAV objects that collects index usage information, and displays it in a NAV client so that you can sort tables by no. of Indexes / Index Reads / (Index) Block wait time, etc.: The tool is using these three SQL Queries / DMVs: sys.indexes: Basic information about indexes sys.dm_db_index_usage_stats: No. of Index Reads, updates, etc sys.dm_db_index_operational_stats
Read More...
Read the complete post at http://blogs.msdn.com/nav_developer/archive/2009/07/16/index-usage-information-tool.aspx
Posted
Jul 16, 2009 8:58
by
Nav developer's blog