Trace flags are switches that adminstrators or developers can use to change the behavior of SQL Server. These are added by the development team, often to help debug or diagnose performance issues, according to BOL, but they are increasingly being used as feature flags to enable behavior that some customers may want, but Microsoft doesn’t want to make the default.

DBCC TRACESTATUS

-- Turn On Trace Flag 3459
DBCC TRACEON(3459, -1)
-- Turn Off Trace Flag 3459
DBCC TRACEOFF(3459, -1)

Sources:

Enable Trace Flags in SQL Server
Last modified: July 21, 2022

Author

Comments

Write a Reply or Comment