Post reply

Blockings

  • 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!

  • July 29, 2008 at 10:58 am

    #849997

    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

  • July 29, 2008 at 1:30 pm

    #850088

    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

  • July 29, 2008 at 11:17 pm

    #850257

    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...

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

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