Microsoft
70-457 · Question #176
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…
The correct answer is D. SELECT * FROM sys.dm_exec_requests WHERE session_id = 60. The sp_helpdb - sp_helpdb [ [ @dbname= ] 'name' - does not accept a spid -
Monitor and Troubleshoot SQL Server
Question
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?
Options
- ASELECT ~ FROM sys.dm_exec_sessions WHERE session_id = 60
- BDBCC OPENTRAN
- CEXEC sp_helpdb 60
- DSELECT * FROM sys.dm_exec_requests WHERE session_id = 60
How the community answered
(49 responses)- A14% (7)
- B8% (4)
- C4% (2)
- D73% (36)
Explanation
The sp_helpdb - sp_helpdb [ [ @dbname= ] 'name' - does not accept a spid -
Topics
#blocking#sys.dm_exec_requests#DMVs#session monitoring
Community Discussion
No community discussion yet for this question.