Salt Lake City SQL Server User Group

Welcome to the Salt Lake City Chapter


Next Meeting: Mon, Sep 18 2017

September SQL User Group with Jimmy May

Language: English
Event Type: In-Person
Online Meeting URL: None

Jimmy May with teach us about advanced AG's in 2016


UTC : Mon, Sep 18 2017 21:00 - 23:00
Event Time : Mon, Sep 18 2017 15:00 - 17:00 Mountain Daylight Time
Your Local Time: Mon, Sep 18 2017 21:00 - 23:00


Doty Family Education Center
Murray, Utah

Featured Presentation

SQL Server 2016 Always On Availability Groups Perf, Internals, & Lessons Learned

Speaker: Jimmy May

Summary: Always On 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. 1. Revealing the fantastic perf enhancements in SQL Server 2016 AGs 2. Sharing SQL Server 2016 AGs Log Transport & Log Redo improvements & internals 3. Documenting the benefits SQL Server 2016 on all flash storage environments, including how to use perform to observe µsec disk latencies

About Jimmy: Jimmy May is a Principal Architect in Microsoft IT. He's formerly a 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 Microsoft Certified Master (MCM). Visit his SQL Server performance & personal productivity blog at Jimmy tweets at



Back to Top