Decrease in performance and "non-yielding scheduler" errors caused by unnecessary spinlocks in SQL Server

Прилага се за: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise

Symptoms


With the introduction of contained databases in SQL Server, the database engine always performs a containment check before executing stored procedures. On high-end computers with multiple cores, this check may cause a decrease in performance because of internal spinlock contention, occasionally causing "non-yielding scheduler" errors.

Resolution


This problem was first fixed in the following cumulative update for SQL Server:
About cumulative updates for SQL Server

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.