blocking processes on a SQL Server instance

Question

Post reply

blocking processes on a SQL Server instance

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

padhis SSCommitted Points: 1762 More actions · Answer 1

spid 318 is blocked by spid 611

Check this article

http://www.sqlservercentral.com/articles/Blocking/64474/

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 2

Chapter 6 - http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 3

<blocking-process> is the culprit and <blocked-process> is the victim.

savethytrees SSCommitted Points: 1968 More actions · Answer 4

I use a script to get the blocking query info. The attached script will give you the SPID, query text, loginname and hostname of the blocked process as well as the blocking process. There is small bug in the script which I am trying to fix but for the most part it works fine and will indeed give you the correct SPID that is causing the blocking.

http://saveadba.blogspot.com/

Blog
http://saveadba.blogspot.com/