Skip to main content
5 votes

Updating rows in Azure SQL Server causing unexpected page splits

After a lot of testing, I believe that Accelerated Database Recovery is the cause. When editing a row, Accelerated Database Recovery will store the difference between the original row and the new row. ...
Andrew Marshall's user avatar
4 votes
Accepted

SQL Server 2019 - sys.dm_db_index_physical_stats - version_record_count

Seems as though this is a documentation issue, as the version_record_count, as suspected, is showing any versioned records and not just those from PVS (due to ADR). Simple repro: create database ...
Sean Gallardy's user avatar
2 votes

Estimate database growth caused by Accelerated Database Recovery

Indeed the only way to be sure is to run a representative workload against a test copy of the database. If you don't have a realistic test environment, you could consider testing this in the cloud. ...
Paul White's user avatar
  • 86.4k

Only top scored, non community-wiki answers of a minimum length are eligible