You administer a Microsoft SQL Server 2012. A process that normally runs in less than 10 seconds has been running for mo

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

You administer a Microsoft SQL Server 2012. A process that normally runs in less than 10 seconds has been running for mo

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply