Administering Microsoft SQL Server 2012/2014 Databases — Question 28

You administer a Microsoft SQL Server.
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?

Answer options

• A. SELECT * FROM sys.dm_exec_requests WHERE session_id = 60
• B. SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60
• C. DBCC INPUTBUFFER (60)
• D. DBCC OPENTRAN
• E. SELECT * FROM sys.dm_tran_session_transactions WHERE session_id = 60
• F. EXEC sp_helpdb A

Correct answer:

Explanation

The correct answer is A, as executing 'SELECT * FROM sys.dm_exec_requests WHERE session_id = 60' allows you to see the current status of the request associated with that session ID, including whether it is being blocked. The other options do not provide information about the blocking status of the specific request; they either show session details, input buffers, or transaction states without focusing on the request's execution status.