You need to find out whether the process is being blocked. Which Transact-SQL statement should you use?
Additional scripts you can use to check up on blocking
http://msdn.microsoft.com/en-us/library/ms176013.aspx
Sunday, December 8, 2013
SQL 2012 - Long running processes and blocked processes
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?
SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60
Additional scripts you can use to check up on blocking
http://msdn.microsoft.com/en-us/library/ms176013.aspx
You need to find out whether the process is being blocked. Which Transact-SQL statement should you use?
Additional scripts you can use to check up on blocking
http://msdn.microsoft.com/en-us/library/ms176013.aspx
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment