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;