SQL Server 2019 ADR questions

sakuraime 2,286 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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,094 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 20,786 Reputation points Microsoft Vendor
    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?