Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

DeadlockPriority Enumeration

Enumerates the priorities used to resolve deadlocks that occur during snapshot generation.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Replication (in Microsoft.SqlServer.Replication.dll)
public enum DeadlockPriority
Member nameDescription
EightSee the Remarks section.
FiveSee the Remarks section.
FourSee the Remarks section.
HighSpecifies that the current session will be the deadlock victim if other sessions involved in the deadlock chain have deadlock priority set to an integer value greater than 5, or is eligible to be the deadlock victim if another session has also set deadlock priority to HIGH or to an integer value equal to 5.
LowSpecifies that the current session will be the deadlock victim if it is involved in a deadlock and other sessions involved in the deadlock chain have deadlock priority set to either NORMAL or HIGH or to an integer value greater than -5.
MinusEightSee the Remarks section.
MinusFiveSee the Remarks section.
MinusFourSee the Remarks section.
MinusNineSee the Remarks section.
MinusOneSee the Remarks section.
MinusSevenSee the Remarks section.
MinusSixSee the Remarks section.
MinusTenSee the Remarks section.
MinusThreeSee the Remarks section.
MinusTwoSee the Remarks section.
NineSee the Remarks section.
NormalSpecifies that the current session will be the deadlock victim if other sessions involved in the deadlock chain have deadlock priority set to HIGH or to an integer value greater than 0, but will not be the deadlock victim if the other sessions have deadlock priority set to LOW or to an integer value less than 0.
OneSee the Remarks section.
SevenSee the Remarks section.
SixSee the Remarks section.
TenSee the Remarks section.
ThreeSee the Remarks section.
TwoSee the Remarks section.
ZeroSee the Remarks section.

Integer values provide fine-grained control over deadlock priority. Priority values specify that the current session will be the deadlock victim if other sessions in the deadlock chain are running at a higher deadlock priority value, but will not be the deadlock victim if the other sessions are running at a deadlock priority value lower than the value of the current session. It also specifies that the current session is eligible to be the deadlock victim if another session is running with a deadlock priority value that is the same as the current session. LOW maps to -5, NORMAL to 0, and HIGH to 5.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.