- In Microsoft SQL Server 2016, you run a query that uses a SQL Server 2016 Query Processor feature. For example, you run a SORT operator in Batch Mode.
- You experience query performance degradation when compared to running the same SORT operator in Row Mode.
- To resolve this problem, you try to enable trace flag 9347 at the session level or use QUERYTRACEON. You do this to disable Batch Mode sorts.
You can also enable this trace flag globally at the server level, session level, or query level.
Note Using trace flags incorrectly can degrade your workload performance.
For more information, see the "Introduction" section of the following Microsoft Knowledge Base article:
2801413 Enable plan-affecting SQL Server query optimizer behavior that can be controlled by different trace flags on a specific-query level
Article ID: 3172787 - Last Review: Sep 14, 2016 - Revision: 1