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.
E
xplanation:
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 ba
tches.
Note: SQL Server wait stats are, at their highest conceptual level, grouped into two broad categories: signal waits and resource waits. A signal wait is accumulated by processes running on SQL Server which are waiting for a CPU to become available
(so called because the process has -signaled- that it is ready for processing). A resource wait is accumulated by processes running on SQL Server which are waiting fora specific resource to become available, such as waiting for the release of a lock on a s
pecific record.
C
4
1
A
0
7
D
5
1
Answer D,
Schema locking issues=Resource Waits Pane(sys.dm_exec_session_wait_stats)
Plan cache memory pressure points=Recent Expensive Queries Pane
Backup I/O problems=Data File I/O Pane
*thanks to Royer*
1
0
This question is very similar to the quizzes for the exam reference of 70-762. The answer is sys.dm_exec_session_wait_stats. the explain nation for not to select activity monitor session is that this tool doesn’t provide enough info to look into the issues. Other tools are also needed.
0
0
answer is D
https://www.wearediagram.com/blog/getting-the-most-out-of-sql-server-part-1-using-activity-monitor
0
0