Blockings

Question

Post reply

Blockings

RGP

SSCarpal Tunnel

Points: 4381
More actions
July 28, 2008 at 11:27 pm

#190373

Detailed Block Report:
-----------------------
Blocker SPID : 65
Resource Type : Table
Resource Blocked : Camdb..cust_Address.cust_Address
----------------------------------------------------------------
Staus: Granted
User Name:
Blocked SPID : 65
Mode: Intent Exclusive
Blocking Lock Type : Table
Command : sp_prepexec;1
Program :
---------------------------------------------------------------
CPU : 438
Phsical I/O : 3039
Wait Time (MS) : 0
Can some one please tell me what does this mean, and how to troubleshoot!

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

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

Deviprasad Ten Centuries Points: 1060 More actions · Answer 1

This describes what is the blocking and the blocked process.

You can see here both are same. i.e. 65. So this says its a self blocking, on the table as mentioned 'cust_Address'.

This statement sp_prepexec;1 is runnign in backend which is causing this block.

Wait Time is 0 Ms, and as this is a self blocking monitor it for some time if this continues longer then you mignt have to kill the process.

Expert's: Please correct if i am wrong.

Thanks

Dev

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

Don't worry about self-blocking. It's usually short lived and just means that pieces of the query are waiting internally for other pieces.

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

RGP SSCarpal Tunnel Points: 4381 More actions · Answer 3

GilaMonster (7/29/2008)
Don't worry about self-blocking. It's usually short lived and just means that pieces of the query are waiting internally for other pieces.

thanks every one...