I would like to remove an index from my database, but I need to verify
that it is not being accessed before I do that.

I tried running Profiler, but it doesn't seem to be giving me the
information I need. I put in a filter for ObjectName, but it seems to
be ignoring it - i get several entries in the profile trace, but no
value in the ObjectName column.

Is there an easy way to monitor for object access?

Thanks so much!

SQL Servef 2000 SP4
(I also have 2005, SP2, if there's a better way to do this with 2005)

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

That is PERFECT!! Thank you so much!


On Apr 26, 12:25 am, "Plamen Ratchev" <Pla... (AT) SQLStudio (DOT) com> wrote:

PERFECT!! Thank you so much!!


On Apr 26, 12:25 am, "Plamen Ratchev" <Pla... (AT) SQLStudio (DOT) com> wrote: