"transaction(Process ID 59) was deadlocked on lock resources with another process and has been choosen as the deadlock victim.Return the transaction"

• kalyan.appdev

  SSC Enthusiast

  Points: 160

  More actions

  July 28, 2010 at 3:42 am

  #98771

  "transaction(Process ID 59) was deadlocked on lock resources with another process and has been choosen as the deadlock victim.Return the transaction"

  I got the above error in production site during high load Iam using sqlserver 2005 , i dont have sql profiler, what would be the problem , When i restart the Sql service ,application works smothly please Help me out of this Situation ….

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  July 28, 2010 at 6:54 am

  #1199200

  Insufficient information provided i would say.

  1) Check the error log

  2) the processid is basically spid , so you could have checked that with "sp_who2 59" and "sp_lock 59"

  and also ""dbcc inputbiuffer (59). that might give you details about victim/culprit.

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)