SQL Server Interview Question #256
What is the version store?
Advanced Transactions & Concurrency Senior Advanced
Detailed Explanation
The version store maintains previous versions of rows required by row-versioning features such as RCSI and SNAPSHOT isolation.
Long-running transactions can force older row versions to be retained for longer periods, increasing version-store space usage. Version-store pressure should therefore be monitored in systems using row-versioning heavily.
The exact storage architecture can vary with SQL Server features and versions, including Accelerated Database Recovery, but the core concept is that readers may access retained row versions rather than blocking writers.