dynamicsusers: Index Usage Query

[Blog bot]

This is a follow up from an earlier blog "Finding Index usage" . In that blog, I described a very simple way to list how indexes are being used. In this blog, the query is much extended so that it now shows your Navision keys, listed by either number of updates, or by their cost divided by their usage, and it shows when an index was last used for reading. The idea is to show a list of indexes that are being maintained, but never or rarely being used. The query uses SQL Server Dynamic Managament...(read more)

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