Soaring to New Heights with Accelerated Database Recovery
summary
Claim: enabling Accelerated Database Recovery (ADR) on SQL Server 2019+ can roll back a 197‑minute transaction in under a second and bring a database online almost instantly. It achieves this by moving non‑versioned state into an in‑memory s_log, moving row versions into a persisted version store (out of tempdb), and using logical revert plus an aborted‑transaction map so locks release immediately. Works in Standard and Azure by default; watch for version‑store bloat, cleaner bottlenecks in 2019, and test high‑churn workloads before enabling.
AI-written summary · about
chapters (17)
- 0:00Introduction
- 3:00Accelerated Database Recovery
- 7:54Why DBAs should care
- 9:00New ADR components
- 13:59ADR availability group awareness
- 15:24Logical revert and versions
- 17:53Aborted transaction map
- 21:26ADR configuration
- 24:59Traditional rollback process
- 26:24ADR rollback changes
- 27:53ADR live demo
- 39:49Instant rollback demo
- 45:22When not to deploy ADR
- 47:14Monitoring and testing ADR
- 50:26ADR benefits summary
- 51:09Further learning resources
- 52:18Q&A
related talks
54mSoaring to New Heights with Accelerated Database Recovery- 54mSoaring to New Heights with Accelerated Database Recovery
49mPerformance Improvements in SQL Server 2019
50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi
50mSQL Server 2022 Performance Enhancements
46mAzure SQL Database Business Continuity During Disaster- 50mSQL Server 2022 Performance Enhancements
- 50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi