Sample Header Ad - 728x90

SQL Server 2019 - sys.dm_db_index_physical_stats - version_record_count

1 vote
1 answer
180 views
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 version_record_count is showing a non-zero value. Question is, if this feature is disabled then why is the DMV telling me that row versions are being retained for tables in each database? The databases in question are using Snapshot Isolation, but I would have thought that the verisons would be stored in tempdb.
Asked by user1722621 (13 rep)
Jan 19, 2024, 04:08 PM
Last activity: Jan 22, 2024, 04:49 PM