Information about enabled trace flags is added to the showplan XML in SQL Server

Applies to: SQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 Enterprise Core More

Summary


In Microsoft SQL Server, the new TraceFlags element is added to the QueryPlan element in the showplan XML. This element lists all trace flags that are enabled at the instance or session level when the query plan is compiled, and for actual execution showplans, a specific query is executed. There can be up to two instances of TraceFlags element, one for compile time (with the IsCompileTime attribute equaling to one), and one for execution time (If a trace flag is enabled during both compilation and execution, it will be presented in both lists). Each element can have a list of one or more TraceFlag elements that have two attributes. The Value attribute identifies the trace flag number, and the Scope attribute can be "Global" or "Session" depending on how the trace flag is enabled (If a trace flag is enabled at the query level by using OPTION QUERYTRACEON, it will appear as in the "Session" scope in showplan).

If no trace flag is enabled during compile or execution time, corresponding elements won't be included.

Note The showplan XML will list up to 100 trace flags that are enabled.

Resolution


Service pack information for SQL Server

This update is fixed in the following service packs for SQL Server:

SQL Server 2016 Service Pack 1

Service Pack 3 for SQL Server 2014

Service Pack 4 for SQL Server 2012