FIX: "Non-yielding scheduler" error when you insert or update many rows in one transaction in SQL Server 2014

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

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

Symptoms

Assume that you have a memory-optimized table that uses In-Memory OLTP in Microsoft SQL Server 2014, and the table is included in an AlwaysOn Availability Group. When you try to insert or update many rows in one transaction in this table, a "non-yielding scheduler" error is generated in SQL Server. Additionally, the failover of the AlwaysOn Availability Group occurs, because the dump file generation takes a long time.

Resolution

The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 3 for SQL Server 2014 /en-us/help/2984923

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server: