Skip to main content
The 2024 Developer Survey results are live! See the results

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
1 vote
1 answer
131 views

SQL Server 2019 - sys.dm_db_index_physical_stats - version_record_count

On a server with SQL Server 2019 Standard Edition installed, none of our databases have the Accelerated Database Recovery enabled yet when I run the DMV - sys.dm_db_index_physical_stats, the column ...
user1722621's user avatar
0 votes
1 answer
237 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 ...
rajendra gupta's user avatar
7 votes
1 answer
253 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 ...
Andrew Marshall's user avatar
3 votes
1 answer
352 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 ...
James Jenkins's user avatar