FIX: "Non-yielding Scheduler" condition when you run a query that contains a UNION operation in SQL Server 2014 or 2016

Symptoms

When you compile or run a query that contains a UNION operation in SQL Server 2014 or 2016, and the rowsets in the union contain lots of columns, a "Non-yielding Scheduler" condition may occur. Then, SQL Server generates a memory dump file.

Resolution

Cumulative update information

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


Recommendation: Install the latest cumulative update for SQL Server

Status

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

Properties

Article ID: 3138321 - Last Review: Jul 26, 2016 - Revision: 1

Feedback