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
Which dynamic management view should you use?
You need to identify which long running transactions use an index.
Which dynamic management view should you use?
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
I agree, C is the correct answer
A is correct ANS