RetiredDBA.com

All things for Microsoft SQL Server

Best Microsoft SQL Server Trace Flags reference

Apr 19, 2018

I bumped into a must have Microsoft SQL Server Trace Flags reference by Konstantin Taranov on github.com.

Mr Taranov has explanations and links to Microsoft articles on the SQL Server trace flags all in one place. The complete list contains 580+ trace flags and additional informational topics:

  • What are Microsoft SQL Server Trace Flags?
  • How do I turn Trace Flags on and off?
  • How do I know what Trace Flags are turned on at the moment?
  • What Are the Optimizer Rules?
  • Recommended Trace Flags
  • Trace flags list

Great webpage to bookmark !