Snapshot Isolation Against Availability Group Secondaries (28 minutes)

In just half an hour, you’ll see how queries against a readable secondary in an Availability Group are automatically escalated to Snapshot Isolation – whether you ask for it or not!

Try the course quiz anytime.

In this course we investigate SQL Server’s version store against a readable secondary, as well as learn about the “low water mark for ghosts” in an Availability Group.

Course scripts are here: https://github.com/LitKnd/SQLWorkbooks/tree/main/snapshot_isolation_against_availability_group_secondaries

Related courses:

Lessons

Automatic isolation level escalation to Snapshot (15 minutes)

Monitoring open transactions and low_water_mark_for_ghosts (13 minutes)

Quiz: Snapshot isolation against Availability Group Secondaries