SELECT * FROM sys.dm_tran_version_store_space_usage SELECT database_id, version_store_reserved_page_count*8 AS reserved_space_kb FROM tempdb.sys.dm_db_file_space_usage -- before SQL Server 2016 SP2)