What’s New for High Availability in SQL Server 2016...
summary
Demonstrations show Windows Server 2016 allowing no domain join clusters for AGs (workgroup clusters with certificate setup) and a live AG built from VMs, plus a demo of S2D/scale‑out file server SMB storage for FCIs. SQL Server 2016 CTP 2.3 adds three automatic synchronous replicas, distributed transactions supported in AGs when enabled at creation, cloud witness (Azure only), storage replica block‑level replication, node quarantine behavior, and active memory dump to shrink crash dumps.
AI-written summary · about
chapters (17)
- 0:00Intro
- 1:34Technical Assistance
- 4:55Explore Everything PASS Has to offer
- 8:49Quick Terminology Recap
- 10:05WSFC without Active Directory
- 19:35Site Awareness for Multi-Site WSFCS
- 23:27Quorum Enhancements
- 25:21WSFC Health Detection
- 26:19New Node States
- 30:05Storage Replica
- 31:33Storage Spaces Direct
- 37:11Rolling OS Upgrades for WSFCs
- 39:08WSFC Troubleshooting Enhancements
- 43:38AG Enhancements 1
- 45:58AG Enhancements 2
- 48:34Group Managed Service Account
- 52:14Summary
related talks
47mNext Level Availability on SQL Server 2022
20mFlying High with Highly Available SQL Server Deployments- 20mFlying High with Highly Available SQL Server Deployments
50mSQL Server 2022 Performance Enhancements
52mBusiness Continuity for Hybrid and Cloud Native SQL Server Deployments
48mThe Kingdom of AdventureWorks Calls for Aid- 20mFlying High with Highly Available SQL Server Deployments
49mEverything you always wanted to know about HA/DR for SQL Server on Azure VMs but were afraid to ask