SET DEADLOCK_PRIORITY

Specifies the relative importance that the current session continue processing if it is deadlocked with another session.

Syntax

SET DEADLOCK_PRIORITY { LOW | NORMAL | HIGH | <numeric-priority> | @deadlock_var | @deadlock_intvar }

<numeric-priority> ::= { -10 | -9 | -8 | … | 0 | … | 8 | 9 | 10 }

Remarks

All argument values are ignored and do not change the default behavior.

Permissions

Requires membership in the public role.

Examples

The following example sets the deadlock priority to NORMAL.

SET DEADLOCK_PRIORITY NORMAL;

See Also