dynamicsusers: Finding Index usage

[Blog bot]

When troubleshooting performance problems, a typical questions is: "which indexes can be disabled on SQL"? This blog shows a simple way to get some ideas of which indexes are used. The method will give some ideas of both how often they are updated (causing overhead), and how often the indexes are actually used. So it gives some ideas of costs and benefits for each index. SQL2005 introduced the concept of Dynamic Management Views (DMVs), which show internal statistics from a lot of different...(read more)

Подробнее... http://dynamicsuser.net/blogs/navsustatine...ndex-usage.aspx