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.
Enroll Today!
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!