Audit table/index access

I inherited a rudimentary data warehouse and would like to gather data on
which tables and which indexes are being used. Queries to the warehouse are
typically issued via ODBC from an ACC2003 front-end.
I have chosen SQL profiler as the tool to identify object usage. I thought
ObjectOpened would provide information on access to tables and indexes,
however, using that (and only that) event produces no results. I have
stripped away all filters.
I initiate a select in query manager, the select returns results. The
profiler session logs no ObjectOpened events. It will log SQL:Statement
started.
Questions:
1) is this the correct tool to use to identify which tables and indexes are
being accessed?
2) am I using the correct event?
3) why no results
Thanks all
======================
JG
Systems/DBA Supervisor
Vermont Agency of Transportation
GIAC Security Certified
MCSE, CCNA
See if this article helps you:
http://www.sql-server-performance.co...on_english.asp
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Vihrea" <Vihrea@.discussions.microsoft.com> wrote in message
news:5562075F-C49C-4D94-9473-3E06EC82E965@.microsoft.com...
> I inherited a rudimentary data warehouse and would like to gather data on
> which tables and which indexes are being used. Queries to the warehouse
are
> typically issued via ODBC from an ACC2003 front-end.
> I have chosen SQL profiler as the tool to identify object usage. I thought
> ObjectOpened would provide information on access to tables and indexes,
> however, using that (and only that) event produces no results. I have
> stripped away all filters.
> I initiate a select in query manager, the select returns results. The
> profiler session logs no ObjectOpened events. It will log SQL:Statement
> started.
> Questions:
> 1) is this the correct tool to use to identify which tables and indexes
are
> being accessed?
> 2) am I using the correct event?
> 3) why no results
> Thanks all
> --
> ======================
> JG
> Systems/DBA Supervisor
> Vermont Agency of Transportation
> GIAC Security Certified
> MCSE, CCNA
>