sqlskills-logo-2015-white.png

SQL Server 2014 SP1 CU8 Available

Microsoft has released SQL Server 2014 Service Pack 1 Cumulative Update 8, which is Build 12.0.4468. This CU has 38 hotfixes in the public fix list. Since the SQL Server 2014 RTM branch is no longer a “supported service pack”, there is no corresponding CU for that branch.

The hotfix below seems interesting, although Microsoft is frustratingly vague about what constitutes a “high-end computer… with multiple cores”

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

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.

There is also no corresponding CU for the SQL Server 2014 SP2 branch, since SQL Server 2014 SP2 was only released on July 11, 2016. This probably means the the CUs for SQL Server 2014 SP1 and SQL Server 2014 SP2 will not be synchronized, which tends to confuse people. Of course, the ultimate solution is to get on the SP2 branch as soon as you are ready.

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.