Home Forums SQL Server 2008 SQL Server 2008 Administration Trace Flags to turn on for SQL instances < 2012 RE: Trace Flags to turn on for SQL instances < 2012
Feivel
SSCertifiable
Points: 7524
More actions
January 22, 2013 at 5:57 am
#1579585
I'll only enable TF 1118...only if I have TempDB contention and even if splitting the files doesn't help. However, as Sql Server Best Practice Analyzer suggests you should add this trace flag as one of the start up parameters.
Regards,
Faisal