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.

Try the course quiz anytime.

In this session, I use diagrams and slides for most of the discussion, with a short amount of demo.

For a deeper dive:

  1. 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
  2. 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

Lessons

Why do we need Snapshot & RCSI? (13 minutes)

How Snapshot and RCSI Provide Consistent Results (12 minutes)

Differences Between RCSI and Snapshot (9 minutes)

Considerations on When to Use RCSI and Snapshot (12 minutes)

Quiz on Read Committed Snapshot Isolation (RCSI) and Snapshot Isolation