Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2012-06-13 : 10:36:16
|
| Blocked Threads on SERVER-QALocks - Blocked Processes: Session 85 has been blocked by session 63 for the last 7729 seconds.Please advise how to truobleshoot and fix. thanks |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-06-13 : 11:17:52
|
| Look in sp_who2 - find the SPID . You'll see information regarding who is blocking. Depending on the circumstances , you may or may not want to KILL the SPID,There may be a legitimate reason. You can use DBCC INPUTBUFFER(session_id) to see the last statementthe client sentJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Blocked Threads