web analytics

You need to evaluate schema locking issues, plan cache memory pressure points, and backup I/O problems. What should you create?

You are experiencing performance issues with the database server.
You need to evaluate schema locking issues, plan cache memory pressure points, and backup I/O
problems.
What should you create?
A. a System Monitor report
B. a sys.dm_exec_query_stats dynamic management view query
C. a sys.dm_exec_session_wait_stats dynamicmanagement view query
D. an Activity Monitor session in Microsoft SQL Management Studio.
Answer: C