Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Symptoms

Consider the following scenario:

  • 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.

In this scenario, the SORT operator still runs in Batch Mode and ignores the session-level or query-level trace flag.

Resolution

In SQL Server 2016, you can use trace flag 9347 to force SORT operators to run in Row Mode instead of executing in Batch Mode. After you apply Cumulative Update 1 for SQL Server 2016, you can successfully enable trace flag 9347 at the session level or query level.

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

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology that Microsoft uses to describe software updates.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×