Questions tagged [accelerated-database-recovery]

Accelerated database recovery (ADR) improves database availability, especially in the presence of long running transactions, by redesigning the database engine recovery process. ADR is new in SQL Server 2019. It is enabled by default in SQL Database and SQL Managed Instance and cannot be disabled.

Filter by
Sorted by
Tagged with
7
votes
1answer
128 views

Updating rows in Azure SQL Server causing unexpected page splits

I'm getting a lot of page splits in a live environment using Azure SQL Server PAAS that I don't understand. The update that's occurring should not increase the size of the row and therefore never ...
3
votes
1answer
102 views

Estimate database growth caused by Accelerated Database Recovery

Accelerated Database Recovery (ADR) is on by default in Azure and an option in SQL Server 2019. It has some really interesting potential. I have experimented by turning ADR on in a static test ...