You need to identify which long running transactions use an index.
Which dynamic management view should you use?
A. sys.dm_exec_query_optimizer_info
B. sys.dm_exec_plan_attributes
C. sys.dm_exec_requests
D. sys.dm_exec_procedure_stats
You need to identify which long running transactions use an index. Which dynamic management view should you use?
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You need to identify which long running transactions use an index. Which dynamic management view should you use?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!