Deadlock

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  June 22, 2011 at 7:42 am

  #253236

  Hi,

  There are two processes and one is deadlocked. How SQL Server knows which process should be killed ?

  Thanks in advance.

• sjimmo

  SSChampion

  Points: 11139

  More actions

  June 22, 2011 at 7:45 am

  #1342382

  Here is a good link about deadlocks - http://msdn.microsoft.com/en-us/library/ms178104.aspx

  Steve Jimmo
  Sr DBA
  “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  June 22, 2011 at 7:46 am

  #1342385

  Usually it's the one that would be easier to roll back - that's if DEADLOCK_PRIORITY is the same for each. Search the internet for "deadlock victim" for more information.

  John