SQL Server 2016 Always On Availability Groups Enhancements

SQL Server 2016 Always On Availability Groups Enhancements

PASS Data Community Summit via YouTube Direct link

Availability Group Topology

6 of 26

6 of 26

Availability Group Topology

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

SQL Server 2016 Always On Availability Groups Enhancements

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Intro
  2. 2 Technical Assistance
  3. 3 HA/DR: Backup & Restore
  4. 4 Other AG Components & Concepts
  5. 5 Failover Cluster Topology
  6. 6 Availability Group Topology
  7. 7 Prototypical Architecture of AGs with Local Non-Shared Storage
  8. 8 Best Practice: Hotfixes & Updates
  9. 9 AGs Enhancements: Fewer Dependencies
  10. 10 SQL Server Standard Edition Support Now that DBM has been marked for deprecation, this is welcome now!
  11. 11 Azure Integration
  12. 12 AGs Enhancements: Security
  13. 13 AGs Enhancements: Failover
  14. 14 AGs Enhancements: DTC Support
  15. 15 AGs Enhancements: Direct Seeding
  16. 16 Log Transport Compression Defaults & Options
  17. 17 Readable Secondary Round-Robin Load Balancing
  18. 18 Readable Secondary Azure Support
  19. 19 Read-Only Secondaries: Licensing & Performance
  20. 20 Best Practice: SORT_IN_TEMPDB
  21. 21 AG Performance Enhancements
  22. 22 Always On AGS: SQL 2016 vs. SQL 2014 (Hekaton)
  23. 23 Unleashing the Power of SQL Server 2016
  24. 24 SQL 2014 vs. 2016: Log Transport Performance (Engine)
  25. 25 SQL Server 2016 Async vs. Sync: Network Bandwidth Support
  26. 26 SQL Server 2014 vs. 2016 CPU% on Primary vs. Transactions (Sync, 3 Replicas, 3 Trials)

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.