Deadlock

• Mvs2k11

  Ten Centuries

  Points: 1221

  More actions

  March 9, 2012 at 10:26 am

  #265685

  Please help.

  I have sqlserver 2008 server and i suspect there is deadlocks happening on a server and I need the details on which database, statement, user, etc. caused the deadlocks with an Extended Events and should notify when the deadlocks error occur.

• seth delconte

  SSCertifiable

  Points: 6388

  More actions

  March 9, 2012 at 12:11 pm

  #1457342

  Try this article: http://qa.sqlservercentral.com/articles/Performance+Tuning/tracingdeadlocks/1324/[/url]

  _________________________________
  seth delconte
  http://sqlkeys.com