Compartilhar via


Enumeração DeadlockPriority

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

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Replication (em Microsoft.SqlServer.Replication.dll)

Sintaxe

'Declaração
<ComVisibleAttribute(True)> _
Public Enumeration DeadlockPriority
'Uso
Dim instance As DeadlockPriority
[ComVisibleAttribute(true)]
public enum DeadlockPriority
[ComVisibleAttribute(true)]
public enum class DeadlockPriority
[<ComVisibleAttribute(true)>]
type DeadlockPriority
public enum DeadlockPriority

Membros

Nome do membro Descrição
MinusTen See the Remarks section.
MinusNine See the Remarks section.
MinusEight See the Remarks section.
MinusSeven See the Remarks section.
MinusSix See the Remarks section.
MinusFive See the Remarks section.
MinusFour See the Remarks section.
MinusThree See the Remarks section.
MinusTwo See the Remarks section.
MinusOne See the Remarks section.
Zero See the Remarks section.
One See the Remarks section.
Two See the Remarks section.
Three See the Remarks section.
Four See the Remarks section.
Five See the Remarks section.
Six See the Remarks section.
Seven See the Remarks section.
Eight See the Remarks section.
Nine See the Remarks section.
Ten See the Remarks section.
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.
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.
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.

Comentários

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.