DBCC TRACESTATUS (-1);
Find all global trace flags that are enabled
TF 3226 – Suppresses logging of successful database backup messages to the SQL Server Error Log
TF 6534 – Enables use of native code to improve performance with spatial data
TF 7745 – Prevents Query Store data from being written to disk in case of a failover or shutdown command
DBCC TRACEON <Ftrace flag>
