Énumération DeadlockPriority

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

Espace de noms :  Microsoft.SqlServer.Replication
Assembly :  Microsoft.SqlServer.Replication (en Microsoft.SqlServer.Replication.dll)

Syntaxe

'Déclaration
<ComVisibleAttribute(True)> _
Public Enumeration DeadlockPriority
'Utilisation
Dim instance As DeadlockPriority

[ComVisibleAttribute(true)]
public enum DeadlockPriority

[ComVisibleAttribute(true)]
public enum class DeadlockPriority

[<ComVisibleAttribute(true)>]
type DeadlockPriority

public enum DeadlockPriority

Membres

	Nom de membre	Description
	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.

Notes

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.

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Replication

DistributorDeadlockPriority

PublisherDeadlockPriority