HomeWinBuzzer NewsMicrosoft Releases SQL Server 2016 Service Pack 1

Microsoft Releases SQL Server 2016 Service Pack 1

The new edition enables developers to build to a single programming surface when creating or updating applications, and use it to scale the application’s needs.


The focus is on the key improvements that allow a consistent programmability surface area for developers and organizations across SQL Server editions.” Developers will benefit from scaling across all editions and cloud as the application advances.

Furthermore, the Service Pack 1 introduces all the supportability and diagnostics improvements first seen in SQL Server 2014 Service Pack 2. There are also new improvements and fixes regarding performance, supportability, programmability and diagnostics. The improvements are based on the valuable feedback from customers and SQL community.

The detailed list of all the new improvements in SQL Server 2016 SP1 is available here.

The Service Pack 1 contains solutions provided in the latest SQL Server 2016 cumulative update – CU3, released on November 8th. Therefore, users don't have to wait for Service Pack 1 to “catch–up” with SQL Server 2016 CU3 content.

Improving Analysis Services

SQL Server 2016 Service Pack 1 also delivers additional performance and scalability enhancements to SQL Server 2016 Analysis Services. The edition offers better NUMA awareness, along with the optimized memory allocation based on Intel Threading Building Blocks (Intel TBB).

The Intel TBB-based scalable allocator helps reduce performance issues due to heap fragmentation. The new edition also helps customers to lower Total Cost of Ownership (TCO) by supporting more users on fewer, more powerful enterprise servers.

says its internal performance and scalability testing shows significant gains in query throughput when running SQL Server 2016 Service Pack 1 Analysis Services on large multi-node enterprise servers, compared to previous Analysis Services versions. However, the company states that the results may vary depending on your specific data and workload characteristics.

The detailed list of SQL Server 2016 Analysis Services improvements is available here

The SQL Server 2016 Service Pack 1 is available for download from the Microsoft Download Center. It is also available as a Feature Pack, a collection of stand-alone packages which provide additional value for Microsoft SQL Server.

The installation may require reboot post installation. Microsoft recommends to plan and perform a reboot following the installation. The company also states that the upgrade is available to all customers with existing SQL Server 2016 deployments.

Microsoft SQL Server 2016 has been made generally available for everyone on June 1st, after leaving the preview phase. Recently, Microsoft brought SQL Server 2016 to preview on the Linux and Windows platform. The release is accompanied by updates to several SQL tools.

Sead Fadilpasic
Sead Fadilpasichttp://journalancer.com/
Sead is a former Al Jazeera journalist who shares his passion for technology on various tech media outlets. Formerly a heavy gamer (semi-professional Warcraft 3 gosu), he now enjoys reviewing software and churning out words about the latest tech-news. He holds a college degree in Journalism and likes to annoy his neighbors by playing one of his three electric and two acoustic guitars.

Recent News