Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

DeadlockPriority Enumeration

 

Applies To: SQL Server 2016 Preview

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
Eight

See the Remarks section.

Five

See the Remarks section.

Four

See the Remarks section.

High

Specifies 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.

Low

Specifies 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.

MinusEight

See the Remarks section.

MinusFive

See the Remarks section.

MinusFour

See the Remarks section.

MinusNine

See the Remarks section.

MinusOne

See the Remarks section.

MinusSeven

See the Remarks section.

MinusSix

See the Remarks section.

MinusTen

See the Remarks section.

MinusThree

See the Remarks section.

MinusTwo

See the Remarks section.

Nine

See the Remarks section.

Normal

Specifies 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.

One

See the Remarks section.

Seven

See the Remarks section.

Six

See the Remarks section.

Ten

See the Remarks section.

Three

See the Remarks section.

Two

See the Remarks section.

Zero

See 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.

Return to top

Community Additions

Show:
© 2015 Microsoft