Overview
Syllabus
Intro
Technical Assistance
HA/DR: Backup & Restore
Other AG Components & Concepts
Failover Cluster Topology
Availability Group Topology
Prototypical Architecture of AGs with Local Non-Shared Storage
Best Practice: Hotfixes & Updates
AGs Enhancements: Fewer Dependencies
SQL Server Standard Edition Support Now that DBM has been marked for deprecation, this is welcome now!
Azure Integration
AGs Enhancements: Security
AGs Enhancements: Failover
AGs Enhancements: DTC Support
AGs Enhancements: Direct Seeding
Log Transport Compression Defaults & Options
Readable Secondary Round-Robin Load Balancing
Readable Secondary Azure Support
Read-Only Secondaries: Licensing & Performance
Best Practice: SORT_IN_TEMPDB
AG Performance Enhancements
Always On AGS: SQL 2016 vs. SQL 2014 (Hekaton)
Unleashing the Power of SQL Server 2016
SQL 2014 vs. 2016: Log Transport Performance (Engine)
SQL Server 2016 Async vs. Sync: Network Bandwidth Support
SQL Server 2014 vs. 2016 CPU% on Primary vs. Transactions (Sync, 3 Replicas, 3 Trials)
Taught by
PASS Data Community Summit