Soaring to New Heights with Accelerated Database Recovery
summary
Explains how SQL Server 2019+ redesigns recovery with an in-memory slog, a persisted version store inside the user database, logical revert and an aborted-transaction map, plus a cleaner thread. Demonstrates a 197‑minute DML transaction that is rolled back in under one second when ADR is enabled, and contrasts hours-to-days rollback without it. Notes tradeoffs: less log but more database space, 2019’s single-thread cleaner can lag on extremely high change rates (2022 fixes this), and enabling is a DB-scoped, exclusive-access change.
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
50mSQL Server 2022 Performance Enhancements
50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi
21mSQL Server 2022 – Time to Rethink your Backup and Recovery Strategy
47mDisaster Recovery Strategies for SQL Server- 47mDisaster Recovery Strategies for SQL Server