Detailed Info Of DeadLocking(Urgent)

• Priti

  Old Hand

  Points: 346

  More actions

  September 16, 2003 at 2:11 pm

  #162365

  I'm having lot of deadlocking occurring in my server, when I do DBCC Traceon(-1,1204,3605). I don't get the commands which cause deadlock, instead I get

  (Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction..) Would the startup parameter gives me detailed information or Is there a way I can capture detailed information. I would appreciate your help

• bfarr23

  Right there with Babe

  Points: 787

  More actions

  September 16, 2003 at 2:29 pm

  #474505

  sp_blocker_pss80(for 2000) is very good for this.

  Read this first:

  http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q271/5/09.asp&NoWebContent=1

• bfarr23

  Right there with Babe

  Points: 787

  More actions

  September 16, 2003 at 2:31 pm

  #474506

  Then read this:

  INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;224453