Microsoft Exam Questions

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?

A.
sys.dm_exec_query_optimizer_info

B.
sys.dm_exec_connections

C.
sys.dm_exec_query_stats

D.
sys.dm_exec_sessions