Pages

Men

rh

11/03/2013

How SQL Server Ends a Deadlock

SQL Server ends a Dead lock by automatically terminating one of the transactions. The process SQL Server uses in the following list.

  • Roll back the transaction of the deadlock victim.
  • Notify the deadlock victim's application.
  • Cancels the deadlock victim's concurrent request.
  • Allows  the other transaction to continue.

No comments :

Post a Comment