Enable Trace Flags in Startup Parameters

• Isabelle2378

  SSCertifiable

  Points: 6174

  More actions

  December 4, 2007 at 10:41 am

  #119593

  Hi,

  I have the following trace flags enabled in my startup parameters:

  -dI:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eI:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lI:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;–T2544;-T2546;–T8004

  We are trying to resolve some memory leak on our server and were told by Microsoft to enable the trace flags in our startup parameters. I added them in and we had a system crash due to memory leaks and it did not generate a dump log. Can anyone tell me if I have the syntax correct? I assumed there needs to be a ; between each trace number? I've looked online to try and find some syntax examples, but can't seem to find any.

  Thanks,

  Isabelle

  Thanks!
  Bea Isabelle

• SQL_ABD

  SSCertifiable

  Points: 5832

  More actions

  December 4, 2007 at 10:51 am

  #757070

  Hi,

  Yes it is.

  Look at the following link

  http://technet.microsoft.com/en-us/library/bb663704.aspx

  Regards,

  Ahmed

• Isabelle2378

  SSCertifiable

  Points: 6174

  More actions

  December 4, 2007 at 10:56 am

  #757076

  Thanks for the info. It looks like I have it in correctly. I wonder why it did not generate the dump log then?

  Isabelle

  Thanks!
  Bea Isabelle

• SQL_ABD

  SSCertifiable

  Points: 5832

  More actions

  December 4, 2007 at 11:33 am

  #757098

  Hi,

  Check what is your Dump directory in the 'SQL Server Configuration Manager'

  http://msdn2.microsoft.com/en-us/library/ms345416.aspx

  Go to this directory to check the trace (the directory is something like D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG)

  Regards