Post reply

blocking

  • November 19, 2013 at 5:33 pm

    #279259

    i notice today blocking in my DB. when i look at wait resource OBJECT: 15:638292499:0

    what does this mean, i look at msdn done see this kind of wait resource

    how to debug which resource it is waiting on ??/

  • November 19, 2013 at 10:33 pm

    #1667666

    Database ID 15 (so the database with an ID of 15 in sys.databases)

    Table ID 638292499 (so the table with an ID of 638292499 in sys.objects)

    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

  • November 20, 2013 at 5:55 am

    #1667756

    thanks what does 0 mean ? i notice blocking sql(spid 79) is a select statement and blocked sql(spid 81) is an insert.

    spid 81 wait resource on Lck_M_IX

  • November 20, 2013 at 6:01 am

    #1667758

    mxy (11/20/2013)

    thanks what does 0 mean ? i notice blocking sql(spid 79) is a select statement and blocked sql(spid 81) is an insert.

    spid 81 wait resource on Lck_M_IX

    Can I recommend you start using sp_WhoIsActive

    It's perfect for this kind of investigation.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • November 20, 2013 at 6:12 am

    #1667761

    Ignore the 0. The database ID and object ID are what you need to identify the table that the blocking is on (and it is a table-level lock).

    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

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

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