SQL Server 2016 Just Works Faster - Performance Improvements in Database

YouTube·PASS Data Community Summit

Explore the performance enhancements in SQL Server 2016 with this 56-minute conference talk from PASS Data Community Summit. Dive into a comprehensive overview of database improvements, presented by Robert Dorr and moderated by Satya Shyam Jayanty. Learn about key features such as DBCC scaling, automatic soft NUMA, deficit scheduling, dynamic CMemThread, indirect checkpoint, and multiple log writers. Discover how spatial capabilities have been enhanced and how vector instructions are utilized. Gain insights into Always On improvements and the new XEvent Linq Reader. Understand the history behind these advancements, the driving issues they address, and future considerations for SQL Server performance optimization.