SQL Server DBA

Concurrency, transaction log management, and database recovery models

Question

Locking READ COMMITTED vs. READ_COMMITTED_SNAPSHOT: how do they handle readers, and when should each be used?

Answer

Locking READ COMMITTED: shared locks, so readers and writers block each other. RCSI: readers get the last committed version as of statement start, no shared locks; versions in tempdb, or the database's persistent version store with ADR. Use RCSI to cut blocking unless code depends on blocking reads.

This is 3 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples