Service
SQL Database
Update Type
Preview Features
Update
Today we are excited to announce the public preview of Accelerated Database Recovery! Accelerated Database Recovery (ADR) is a new SQL Server Engine feature (available in Azure SQL, Azure SQL Data Warehouse, and SQL Server on-premises) that greatly improves database availability, especially in the presence of long running transactions, by completely redesigning the current SQL Server recovery process from the ground up. The primary benefits of ADR are: Fast and consistent Database Recovery With ADR, long running transactions do not impact the overall recovery time, enabling fast and consistent database recovery irrespective of the number of active transactions in the system or their sizes. Instantaneous Transaction rollback With ADR, transaction rollback is instantaneous, irrespective of the time that the transaction has been active or the number of updates that has performed. Aggressive Log Truncation With ADR, the transaction log is aggressively truncated, even in the presence of active long running transactions, which prevents it from growing out of control.
Context
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-accelerated-database-recovery
Reference
https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/10/16/accelerated-database-recovery/

Back to List