Which Transact-SQL statement should you use?

You administer a Microsoft SQL Server 2012.

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?
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

Answer: A

Latest 70-462 Dumps Valid Version with 301 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments