Explore curious cases of Availability Groups in this informative PASS Data Community Summit talk. Delve into common and uncommon scenarios encountered when implementing Availability Groups in production environments. Learn about readable secondaries, side effects, multiple listeners, in-memory OLTP, and nondurable tables. Discover solutions to challenges such as database migration, removing mirroring, and configuring historian mode. Gain insights on updating statistics on read-only secondaries, running old cardinality on read-only databases, and improving log transmission. Address practical concerns like firewall configuration, secondary connections, and routing. Equip yourself with valuable knowledge to tackle Availability Group implementation issues in your professional endeavors.
Overview
Syllabus
Introduction
Replicas
What happens when I add as readable secondary
Side effects
Secondary replicas
Multiple listeners
Inmemory OLTP
Nondurable tables
Possible solution
Demo
Preparation
Last Name
Database Migration
Remove Mirroring
Historian Mode
Questions
How can I do readonly secondary update statistics
How can I run old cardinality on readonly databases
Microsoft improve the way that the log is being sent
You dont need to configure
Firewall
Secondaries
Connections
Routes
Conclusion
Taught by
PASS Data Community Summit
