Post reply

Default Deadlock Timeout Period

  • May 7, 2010 at 12:44 pm

    #146928

    Guys,

    I cannot find out how long the deadlock timeout period is for SQL Server. In other words, how long after the deadlock is detected does SQL Server wait before it kills the process it chooses as the deadlock victim?

    I cannot find this anywhere. Is this something you can control? I don't see a config parameter - am I just missing something?

  • May 7, 2010 at 3:49 pm

    #1164487

    There is no deadlock wait period, which is why you cannot find any information. When a deadlock is detected, the transaction that needs the least amount of resources to reverse is rolled back.

    SQL = Scarcely Qualifies as a Language

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

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