Next Level Availability on SQL Server 2022
summary
SQL Server 2022 introduces concrete availability changes: distributed availability groups add an opt‑in zero‑data‑loss failover (guaranteed but with a network‑dependent performance cost), and the new manage instance link uses distributed AGs to enable hybrid no‑downtime migration and DR to Azure SQL MI. Under‑the‑hood throughput doubles TCP log channels and replaces per‑database static 100 redo threads with a global redo thread pool, plus richer diagnostics. Peer‑to‑peer gains last‑writer‑wins via hidden column timestamps, contained AGs replicate master/msdb templates through the AG listener, and T‑SQL snapshot backups plus ADR speed recovery.
AI-written summary · about
chapters (12)
- 0:00Intro
- 3:27SQL Server 2022 Engine Availability Improvements
- 6:39Disaster recovery
- 11:45High Availability Journey
- 16:38SQL Server 2022 High Availability New Feature Overview
- 18:30Distributed AG Failover Improvements
- 23:23AG Perf and Stability improvements
- 26:36Multi-write replication
- 29:02Problem Statement
- 32:46System Databases
- 41:26Traditional SQL Server backups
- 42:24T-SQL Snapshot backup
related talks
50mSQL Server 2022 Performance Enhancements
01h 00mWhat’s New for High Availability in SQL Server 2016...
44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance- 50mSQL Server 2022 Performance Enhancements
19mThere and back again: SQL Server 2022 - Managed Instance
52mHADR on SQL Server on Azure VMs: Everything you Need to Know- 44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance
50mManaged Instance Link - Seamless migration to Azure