The introduction of AlwaysOn with SQL Server 2012 Enterprise Edition allowed administrators to address the need for a simpler, more granular method of configuring High Availability without the need for traditional shared storage. The effectiveness of an AlwaysOn implementation in SQL Server 2014 was in part limited by the throughput capabilities of the log transport function. This presentation discusses:
  • A review of Enhanced Availability Groups
  • Log Transport Improvements
  • A functional comparison of SQL Server 2014 SP1 CU7 vs SQL Server 2016 RC2 using SanDisk Fusion ioMemory
Presented by Niall MacLeod at SQLBits XV