Re: Monitor Object Access

From: "Plamen Ratchev" <Plamen@xxxxxxxxxxxxx>
Date: Thu, 26 Apr 2007 05:25:48 GMT

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

.

Follow-Ups:
- Re: Monitor Object Access
  - From: traceable1
- Re: Monitor Object Access
  - From: traceable1

References:
- Monitor Object Access
  - From: traceable1

Prev by Date: Re: sql script
Next by Date: Re: READ UNCOMMITTED data
Previous by thread: Monitor Object Access
Next by thread: Re: Monitor Object Access
Index(es):
- Date
- Thread