INF: Specifying Priority for Deadlock Victim Selection

ID: Q58534

The information in this article applies to:

Microsoft SQL Server versions 4.2x, 6.0, 6.5, 7.0

SUMMARY

In Microsoft SQL Server version 4.2x, when a deadlock condition occurs between two user-defined transactions, the transaction that has used more resources is allowed to continue and the other is rolled back.

In Microsoft SQL Server version 6.0, you can prioritize deadlock settings by using the SET DEADLOCK_PRIORITY statment. For more information on setting deadlock priority, see Microsoft SQL Server Books Online, "Transact- SQL Reference", the SET statement.

Additional query words: sql6 deadlock locking

Keywords : kbenv SSrvLock
Version : winnt:4.2x,6.0,6.5,7.0
Platform : winnt
Issue type :