Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

How to enable SQL Server trace flags at startup

05 October,2022 by Tom Collins

Question: How do I enable SQL Server trace flags at startup ?   


Answer:  To add a trace flag as a SQL Server startup parameter, use SQL Server Configuration Manager. By adding the trace flag as a start up parameter - 

  1. Start SQL Server Configuration Manager.  An alternative is to start  SQL Server Configuration Manager from Command Line
  2. Choose SQL Server Services is selected 
  3. On the right panel, right-click the SQL Server service instance -> Properties.
  4. Choose Startup Parameters tab.
  5. In the textbox, titled "Specify a startup parameter"  type the -T switch command  e.g -T 460 and then click Add. The parameter is added to the Existing parameters list.
  6. Click OK.



Read more on trace flags

Trace flag 610 and High performance data loading

List SQL Server DBCC commands using trace 2520 – documented and undocumented commands

How to trace SQL Server Backup


Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on How to enable SQL Server trace flags at startup | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer