The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Nov 15 2016 02:30 UTC


SQL Server 2016 Always On Availability Groups Perf Enhancements & Internals

RSVP: https://attendee.gotowebinar.com/register/4940025857138159875

SQL Server 2016 Always On Availability Groups Perf Enhancements & 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 over 1/2GB/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. Jimmy May is a SQL Server Solutions Architect for the Data Propulsion Labs at SanDisk. He is a Microsoft Certified Master (MCM). He's formerly 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 Lab 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.


Jimmy May is a Microsoft Certified Master (MCM). He's formerly 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 Lab which hosts the biggest, fastest, & most interesting SQL Server apps from all over the world. More recently he was a SQL Server Technologist for what was Fusion-io's Data Propulsion Lab (DPL). He is a founder of the IndyPASS & IWUG user groups.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids