Forcing Cleanup
There’s a stored procedure called sp_persistent_version_cleanup we can use to clean out PVS data.
There’s some helpful information about it in sp_helptext:
create procedure sys.sp_persistent_version_cleanup ( @dbname sysname = NULL, -- name of the database. @scanallpages BIT =…