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_connections
C.
sys.dm_exec_query_stats
D.
sys.dm_exec_sessions
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
C is the only one having a plan handle which can be used by cross applying sys.dm_exec_query_plan and then querying the XML
0
0
I agree, C is the correct answer
0
0
A is correct ANS
0
0