Common DBCC Trace Flags and their uses…

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 


Posted

in

,

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *