Trace Flags Report
The Trace Flags report is one of the instance level reports in Database Health Monitor.
If you have trace flags enable on SQL Server they will be listed in the Trace Flags Report.
Some of my Favorite Trace Flags are:
- Trace Flag 3226 – Silence backup messages to the error log.
- Trace Flag 1117 – Grow all files in a file group equally. Works good with TempDB’s with multiple files.
- Trace Flag 1118 – Use Full Extents only. Works best with TempDB.
- Trace Flag 3023 – use CHECKSUM on backups
Need help?
If you need help configuring trace flags or anything else with your SQL Server, you can contact me (Steve Stedman) through my SQL Server consulting business Stedman Solutions, LLC.