What should you create?
A. a sys.dm_exec_session_wait_stats dynamicmanagement view query
B. an Activity Monitor session in Microsoft SQL Management Studio.
C. a System Monitor report
D. a sys.dm_exec_query_stats dynamic management view query
Answer:A
What should you create?
A. a sys.dm_exec_session_wait_stats dynamicmanagement view query B. an Activity Monitor session in Microsoft SQL Management Studio. C. a System Monitor report D. a sys.dm_exec_query_stats dynamic management view query
Explanation: sys.dm_exec_session_wait_stats returns information about all the waits encountered by threads that executed for each session. You can use this view to diagnose performance issues with the SQL Server session and also with specific queries and batches.