KB3124043 - FIX: Query stops responding in SQL Server 2014 after you enable trace flag 2430 - Microsoft Support

Support

Sign in

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.

Applies To

SQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use)

Symptoms

Assume that you enable trace flag 2430 as a startup parameter in an instance of Microsoft SQL Server 2014. When you execute a query, SQL Server stops responding.

Resolution

Cumulative Update information

The issue was first fixed in the following cumulative update for SQL Server 2014:

Cumulative Update 4 for SQL Server 2014 SP1

Recommendation Install the latest cumulative update for SQL Server

Email

SUBSCRIBE RSS FEEDS

Need more help?

Want more options?

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

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center