Home » Microsoft » 70-764 v.2 » What should you do?
You have a database named DB1.
Users report that a database application that updates the data in DB1 is unresponsive.
You need to identify which process prevents the application from responding.
What should you do?
A. Run DBCC INPUTBUFFER.
B. Query sys.dm_exec_session_wait_stats.
C. Run sp_autostats.
D. Run sp_who.
Correct Answer: B
Explanation/Reference:
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.
References: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-session-wait-stats-transact-sql