Deadlock trace

• karthikeyan-146504

  Ten Centuries

  Points: 1055

  More actions

  March 9, 2009 at 3:28 am

  #95271

  Hi,

  If I enable the deadlock trace in production,

  Is it going to affect the performance of apps connected to it?

  Thanks,

  ---

  Kindest Regards,

  karthik
  

• amarnath_sk

  Right there with Babe

  Points: 740

  More actions

  March 9, 2009 at 3:55 am

  #955852

  http://www.simple-talk.com/sql/learn-sql-server/how-to-track-down-deadlocks-using-sql-server-2005-profiler/

• karthikeyan-146504

  Ten Centuries

  Points: 1055

  More actions

  March 9, 2009 at 3:57 am

  #955853

  I meant serverside trace for deadlock..

  Thanks,

  ---

  Kindest Regards,

  karthik
  

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 9, 2009 at 7:08 am

  #955942

  Do you mean a server-side trace or enabling trace flag 1222?

  Either one will add some load to the server. Using a server-side trace will allow you to gather more data, but you will need to do it correctly in order to minimize the load. Typical recommendations are to create 2 server-side traces, 1 for the deadlock graph and another with a filter on database to get locking and sql statement information at the time of the deadlock. If you include the EventSequence column in your traces you can use that to see the order in which things happen.

  Are you having deadlock problems?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question