By setting DEADLOCK_PRIORITY, system will determine the relative importance that the current session continue processing if it is deadlocked with another session. It can be set with numeric too.

For example, if SET DEADLOCK_PRIORITY LOW, this session will become victim of deadlock if other session is set to NORMAL / HIGH. While SET DEADLOCK_PRIORITY NORMAL, it will become victim only when other session is set to HIGH.

Tags: Transact-SQL