[Tweet “#SQL2016 – what you need to know about #AlwaysOn AG enhancements @PASS24HoP”]
Brew a fresh pot of coffee and be ready for the 24 Hours of PASS: Evolution of the Data Platform. Yes, it’s that time of the year, and I’m thrilled to share that my session on SQL Server® 2016 Always On Availability Groups (AGs) Enhancements was one of the most highly rated by the Program Committee and earned the coveted third slot at the event!
@PASS24HoP is a 24-hour long global event sponsored by the preeminent SQL Server organization on the planet, the Professional Association for SQL Server (PASS). My session will take place on Wednesday, May 25th at 10 a.m. EDT / 7 a.m. PDT / 2:00 p.m. UTC, where I will review the spectrum of feature and performance enhancements introduced in SQL Server 2016 Always On Availability Groups.
Always On Availability Groups (AGs)
Always On Availability Groups is SQL Server’s preferred high availability/disaster recovery (HA/DR) feature. AGs were introduced in SQL Server 2012 and improved in SQL Server 2014. Yet in SQL Server 2016 a wide range of fantastic enhancements are delivered, including performance enhancements that require flash to leverage them. The SanDisk® Data Propulsion Lab (DPL) has been busy putting the new bits through their paces—with fantastic outcomes.
Our work shows enhancements of 5x – 10x, allowing over ½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.
Always On Availability Groups: SQL Server 2016 Enhancements
Here’s a partial agenda of the new! improved! functionality and performance:
- SQL Server Standard Edition support(!)
- Domain independent AG support
- Load-balanced readable secondaries
- Direct seeding of new DB replicas
- Enhanced Azure integration
- And more—including “AlwaysOn” now re-named to “Always On” (yes, really)
Most exciting of all are the performance improvements:
- Log transport
- Log redo
These changes move the bottleneck from the SQL Server codebase, allowing improved CPU utilization and far higher transaction rates. And the benefits aren’t limited to performance: this real-time transport of transactions to secondary replica(s) renders the data immune to failure of the primary servers and therefore results in improved RPO.
Join Me at 24 Hours of PASS: Evolution of the Data Platform!
See all 24 fantastic round-the-clock sessions for yourself. Learn about my session, SQL Server 2016 Always On Availability Groups Enhancements, and register for the event here.