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!

We’ll investigate the 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:

Modules

Menu