SQL 2005 - Get Deadlock information

• balasach82

  SSCrazy Eights

  Points: 9653

  More actions

  March 25, 2013 at 9:56 am

  #275620

  IN sql 2005, I use DMV to get the number of deadlocks per sec. How can i get those deadlock's details? I havnt enabled the Traces or run profiler. These deadlocks already happend and i suspect if we could get the necessray details

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 25, 2013 at 10:36 am

  #1600414

  There's no way to get historical deadlocks in SQL 2005 unless you already had some traceflag or trace on at the time.

  To catch future deadlocks, turn traceflag 1222 on, the deadlock graph will then be written to the error log.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass