Currently enabled globally trace flags…
DBCC TRACESTATUS(-1);
1117 – Grow All Files in a File Group Equally
1118 – Full Extents Only
1204 – Focused on the nodes involved in the deadlock. Each node has a dedicated section, and the final section describes the deadlock victim.
1208 – Prints the host name and program name supplied by the client. This can help identify a client involved in a deadlock
1222 – Function: Returns the resources and types of locks that are participating in a deadlock and also the current command affected
2371 – Function: Changes the fixed auto update statistics threshold to dynamic auto update statistics threshold.
Note: Beginning with SQL Server 2016 this behavior is controlled by the engine and trace flag 2371 has no effect.
4199 – Function: Enables query optimizer (QO) changes released in SQL Server Cumulative Updates and Service Packs.
8649 – Run Query Parallel
Leave a Reply