May 7, 2010 at 12:44 pm
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
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy