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!
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 |