You need to identify which long running transactions use an index. Which dynamic management view should you use?
Posted: Mon Oct 17, 2022 4:49 pm
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
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