Read Committed Snapshot and Snapshot Isolation (46 minutes)
This course is an overview of why Read Committed Snapshot Isolation (RCSI) and Snapshot Isolation levels are critical for scaling workloads in SQL Server. In this session, I use diagrams and slides for most of the discussion, with a short amount of demo.
For a deeper dive:
- Complete the Read Committed is Bonkers course first, and then skip the “Welcome” lesson in this course — it is a recap of the problems with Read Committed
- Follow this course up by taking the course Snapshot Isolation Against Availability Group Secondaries
Get the scripts for this course here: https://github.com/LitKnd/SQLWorkbooks/tree/main/rcsi_and_snapshot_isolation