FIX: Non-yielding scheduler error when using SQL Server Query Store in SQL Server

Applies to: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer

Symptoms


When you use the SQL Server Query Store feature in Microsoft SQL Server 2016, a “Non-yielding Scheduler” error may occur. Additionally, a mini-dump file is generated in the SQL Server Application log folder.

Cause


This problem occurs during the execution of a Query Store background task. If there are many plans in the Query Store, CPU starvation may occur for other worker threads that run on the same scheduler. This can cause a non-yielding scheduler error.

Resolution


This fix is included in Cumulative Update 6 for SQL Server 2016 Service Pack 1.

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 Microsoft uses to describe software updates.