INF: Specifying Priority for Deadlock Victim Selection (58534)


The information in this article applies to:

  • Microsoft SQL Server 4.2x
  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 7.0
This article was previously published under Q58534

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.
Modification Type:MinorLast Reviewed:2/14/2005
Keywords:kbenv KB58534
©2004 Microsoft Corporation. All rights reserved.