Post reply

Deadlock without victim

  • May 28, 2014 at 4:30 am

    #291739

    Can there be a case that deadlock happens and Sql doesn't choose any victim and No transaction got rollback/killed.

    and DBA has to KILL any one of transaction ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • May 28, 2014 at 5:15 am

    #1716963

    Bhuvnesh (5/28/2014)

    Can there be a case that deadlock happens and Sql doesn't choose any victim and No transaction got rollback/killed.

    and DBA has to KILL any one of transaction ?

    Depending upon your SQL Server version, yes. Google "sql server unresolved deadlock" to see a few examples including Connect items and their resolution.

    Assuming this is not a rhetorical question and you think this is happening in your environment, what evidence do you have that an unresolved deadlock is occurring?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • May 28, 2014 at 2:22 pm

    #1717160

    Yes, it can happen. I had a situation when 3 SPID's were blocking each other in a circular mode. I got an impression that SQL Server does not handle such deadlocks. Had to kill one of them manually.

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

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