Enabling trace flag 1204

• Sardar Patil

  SSC Enthusiast

  Points: 168

  More actions

  September 19, 2006 at 8:18 am

  #68438

  Hi

  I want to get the details of the deadlock issues from sql server log. For that I would need to enable trace flag 1204 and 3605 on my production enviornment.

  Does enabling this flag cause any perfornmance issues ? Or is there any disadvantage of enabling it ?

  Regards

  Sardar

   

• Holger Steidel

  SSChasing Mays

  Points: 602

  More actions

  September 22, 2006 at 6:53 am

  #661958

  Hi Sardar,

  every traceflag can bring performance issues. But to analyse your deadlock issues you should have a look at the blockerscript. You can find it here:

  http://support.microsoft.com/kb/298475/

  Regards,

  Holger

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  September 22, 2006 at 9:10 am

  #662007

  just to comfort you a bit :

  - 1204 and 3605 are set as startup parameters at all our sqlserver instances

       (24/7/ +-365)!

  - We switch sqlserver logfiles (errorlogs) at least every week using  DBCC errorlog (scheduled job)

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• Sardar Patil

  SSC Enthusiast

  Points: 168

  More actions

  September 25, 2006 at 1:12 am

  #662136

  Thanks a lot for your valuable sugessions