SQL Server 2016 Always On Availability Groups Perf Enhancements and Internals
AlwaysOn Availability Groups (AGs) were introduced in SQL Server 2012. AGs significantly expanded our HA/DR options. However, in both SQL 2012 and SQL 2014 two limitations were extant in the code – both Network Transport and Log Redo significantly compromised performance. In SQL Server 2016, these limitations have been significantly improved. Our work shows enhancements of 7x – 10x, allowing over1/2 GB/s (4GB/s) across the wire. These improvements expand solutions options for tier 1 OLTP and Data Warehouse workloads, Tier 1 and Tier 2 consolidation, and more. This presentation explains the improvements, characterizes the new solutions, and shows commodity servers and modern non-shared in-server flash storage showing the profound contrast between SQL Server 2014 vs 2016. Doing so moves the performance bottleneck from the SQL Server codebase to the CPU where it belongs.
About the Speaker
Jimmy May is a SQL Server Solutions Architect for the Data Propulsion Labs at SanDisk. He is a Microsoft Certified Master (MCM). He is formally a Principal Architect at Microsoft as well as Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Labs which hosts the biggest, fastest, & most interesting SQL Server apps from all over the world. He is a founder of the IndyPASS & IWUG user groups.
You can follow Jimmy digitally on twitter (@aspiringgeek)