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
Last activity: Jan 22, 2024, 04:49 PM