Read Committed Snapshot Isolation and tempdb I/O Latency
SQL Server's Read Committed Snapshot Isolation (RCSI) is designed to eliminate blocking between concurrent read and write operations by utilizing row versioning. This mechanism shifts the concurrency burden from the lock manager to the version store located in tempdb . In environments with high concurrency and frequent updates to large datasets, the overhead
microsoftsqlserver