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.
3
questions
7
votes
1
answer
222
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 ...
- 121
3
votes
1
answer
217
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 ...
- 6,178
0
votes
1
answer
78
views
Accelerated Database Recovery SQL Server
I have ADR enabled on my production database running on SQL Server 2019. In the SQL Server logs , it shows the messages:
[VersionCleaner][DbId:6][sweepOfSelectivePages]: Cleanup of sidelist
aborted ...
