Show Unused Indexes

captdon

As databases and applications evolve, some indexes may no longer be needed. Since indexes affect performance when rows are Inserted, Updated or deleted;

Identifying unused indexes and removing them would boost performance.

Another benefit would be memory and disk storage savings.

rick.sellers

I voted this up, but with the caveat that the counters in the DMV get reset when SQL Server is restarted.  A warning to that effect should be placed on the page where this information is displayed.  As always, knowing how to use the information provided is critical to getting the best performance out of SQL Server.