Queries behind index hits

anushahanna
anushahanna used Ask the Experts™
on
Is it possible to get the queries behind the Indexes that are hit (recorded in sys.dm_db_index_usage_stats)

thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
Not automatically you can get some information if you run the trace

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial