Soaring to New Heights with Accelerated Database Recovery

on YouTube ↗54m

" summary

Accelerated Database Recovery (ADR) redesigns crash recovery with an in-memory slog, a persisted version store moved into the user database, and a logical revert that releases locks immediately. Demo shows a 197-minute transaction rolled back to online in less than a second. ADR enables aggressive log truncation, is AG-aware and default in Azure SQL, but 2019 has a single-threaded cleaner that can cause version-store growth under very high DML; enabling is a database-scoped ALTER requiring exclusive access.

AI-written summary · about

" chapters (17)

1. 0:00Introduction
2. 3:00Accelerated Database Recovery
3. 7:54Why DBAs should care
4. 9:00New ADR components
5. 13:59ADR availability group awareness
6. 15:24Logical revert and versions
7. 17:53Aborted transaction map
8. 21:26ADR configuration
9. 24:59Traditional rollback process
10. 26:24ADR rollback changes
11. 27:53ADR live demo
12. 39:49Instant rollback demo
13. 45:22When not to deploy ADR
14. 47:14Monitoring and testing ADR
15. 50:26ADR benefits summary
16. 51:09Further learning resources
17. 52:18Q&A

" related talks

• 54mSoaring to New Heights with Accelerated Database RecoveryJohn Morehouse · SQLBits 2019
• 54mSoaring to New Heights with Accelerated Database RecoveryJohn Morehouse · SQLBits 2022
• 46mAzure SQL Database Business Continuity During DisasterTaiob Ali · SQL Server Virtual Conference 2021
• 49mPerformance Improvements in SQL Server 2019Frank Gill · SQL Server Virtual Conference 2021
• 50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engiAjay Jagannathan · SQLBits 2022
• 54mDesigning Azure Data Disaster Recovery StrategiesJohn Morehouse · SQLBits 2020
• 47mDisaster Recovery Strategies for SQL ServerAndrew Pruski · SQLBits 2019
• 31mAutonomous Database: Simplify your database managementYasin Baskan · Oracle DatabaseWorld 2021