where we can see the Row Versioning

Row versions are stored internally in the Version Store within TempDB. Although SQL Server does not expose the actual versioned rows through a regular table, it provides several DMVs that allow us to monitor row versioning activity. The most important are sys.dm_tran_version_store_space_usage, which shows version store consumption per database; sys.dm_db_file_space_usage, which shows TempDB space used by versioning; and sys.dm_tran_active_snapshot_database_transactions, which identifies active transactions consuming row versions. In production environments, these DMVs are critical for troubleshooting TempDB growth and long-running snapshot transactions. While the actual row versions are stored internally and linked through version pointers, SQL Server does not provide a supported mechanism to directly query historical row values from the Version Store. Understanding these DMVs is essential when working with Snapshot Isolation and Read Committed Snapshot Isolation because excessive version store growth can lead to TempDB performance issues.