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