FIX: Non-yielding Scheduler error may occur with Always On availability group in Microsoft SQL Server

Applies to: SQL Server 2016 Service Pack 2SQL Server 2016 DeveloperSQL Server 2016 Enterprise

Symptoms


You mayexperience non-yielding scheduler in Microsoft SQL Server that's the primaryreplica of Always On availability group (AG) when the SQL Server instance is underlow memory. Additionally, the following entry is logged in the SQL Server error log:

DateTime Server      Process 0:0:0 (0x1fa4) Worker 0x000001024B232160 appears to be non-yielding on Scheduler 3. Thread creation time: 13215777539641. Approx Thread CPU Used: kernel 4932703 ms, user 5961140 ms. Process Utilization 15%. System Idle 81%. Interval: 10902277 ms.

Status


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

Resolution


This issue is fixed in the following cumulative updates for SQL Server:
About cumulative updates for SQL Server:
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:

References


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