Post reply

Blocking transaction

  • January 10, 2010 at 11:21 pm

    #386071

    Hai friends,

    i need help, i have posted two queries. these two queries have generate blocking transaction. i want to know why they are generating blocking and how to recover from that.

  • January 11, 2010 at 2:18 am

    #1101656

    Please post queries, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    I don't know what's in that bmp file, because I'm not downloading 2.5 MB to look at a picture. If it's the queries, post them as test in the forum thread. If it's a blocking graph, deadlock graph or the like, either post the (zipped) xml, or save the pic as a .png or .jpg for those of us who do not have unlimited internet bandwidth.

    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

  • January 11, 2010 at 7:01 am

    #1101754

    Curiosity got the better of me...smaller PNG version attached.

    edit: And now I have looked at it. It's a screenshot of a blocked/blocking transaction report in SSMS. It shows information for the blocked statements, but the blocking statement text is very helpfully not expanded.

    I'll wait for the OP to post something I can work with.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • January 12, 2010 at 11:55 am

    #1102650

    does table TeamManHours have some sort of relationship with table Darhead?

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

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