Administering a SQL Database Infrastructure — Question 193

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?

Answer options

• A. Run DBCC INPUTBUFFER.
• B. Query sys.dm_exec_session_wait_stats.
• C. Run sp_autostats.
• D. Run sp_who.

Correct answer: B

Explanation

The correct answer is B because querying sys.dm_exec_session_wait_stats provides insights into the wait statistics for each session, helping to identify blocking processes. Option A, DBCC INPUTBUFFER, provides information about the last statement executed by a session but may not indicate the cause of unresponsiveness. Option C, sp_autostats, is related to automatic statistics updates and does not pertain to session issues. Option D, sp_who, gives a list of users and processes but lacks detailed wait information compared to option B.