Posted by Plamen Ratchev on 04/26/07 05:25

In SQL Server 2005 I have used the sys.dm_db_index_usage_stats dynamic
management view to check for index usage. Essentially a new row is added for
the index when it is used. The catch is that the info in
sys.dm_db_index_usage_stats is reset when the SQL Server service is
restarted.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: READ UNCOMMITTED data
• Prev in forum: SqlCacheDependency based on what notification event??
• Thread view: Re: Monitor Object Access

[Reply to this message]