SQL Server 2019 ADR questions

sakuraime 2,346 Reputation points
2021-07-08T07:59:05.35+00:00

the database in sql server 2019 enabled ADR , when I update a column like size in 10GB , will the original mdf for that database grow 10GB due to version store ?

And also for rollback, the modified extent are overwrite from that in the version store , how long will it takes ? Or just some back end metadata pointing or switch over??

and for the insert statement , will it also create version store ??

SQL Server | Other
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2021-07-08T09:30:39.14+00:00

    Hi @sakuraime ,

    > will the original mdf for that database grow 10GB due to version store

    No. The extra versioning information leads the mdf file growing, but the size will less than 10 GB. There is a new asynchronous cleaner process, which iterates through all relevant databases (similar to ghost cleanup) and deallocates unneeded page versions. It runs every minute.

    Suggest you to read the blog Accelerated Database Recovery in SQL Server 2019 and How Does Accelerated Database Recovery Work?


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.