dbcc traceon

• W R

  Mr or Mrs. 500

  Points: 523

  More actions

  November 8, 2006 at 9:10 am

  #115258

  After  dbcc traceon (3605, 1204, -1) has been executed, does stoppig and starting SQL Server set the trace off.

  Thanks.

  W K

• lucky-80472

  SSCertifiable

  Points: 7793

  More actions

  November 8, 2006 at 10:13 am

  #670645

  Hello,

  Trace flags, after they are enabled, remain enabled in the server until disabled by executing a DBCC TRACEOFF statement.

  To determine the status of trace flags, use DBCC TRACESTATUS. To disable trace flags, use DBCC TRACEOFF.

  Hope this helps.

  Thanks

   

  
  Lucky

• W R

  Mr or Mrs. 500

  Points: 523

  More actions

  November 8, 2006 at 10:35 am

  #670649

  Thanks for your comments.

  I did run dbcc tracestatus earlier and it shows that the trace is not on. But, I did run dbcctraceon and did not run dbcctraceoff. Only thing that happened was SQL Server service was stopped and started.

  -W R

   

   

• Jason P. Burnett

  SSCommitted

  Points: 1759

  More actions

  November 9, 2006 at 5:24 am

  #670804

  I have an enterprise application that I battle a lot of deadlocking with.  I have always seen that when I enable the trace flags for deadlock info that they disable when the service restarts.  I believe you can set this to automatically start via the startup parameters when the service starts; however I have never been very comfortable with manipulating this.  I have my trace flags being enable at service start via a startup stored procedure, although some people are very uncomfotable with this apporach as well.  I have never experience and issue with it and I have been doing it for several years.  Hope this helps.

  Regards,

  Jason P. Burnett
  Senior DBA