Главная
Study mode:
on
1
Introduction
2
Replicas
3
What happens when I add as readable secondary
4
Side effects
5
Secondary replicas
6
Multiple listeners
7
Inmemory OLTP
8
Nondurable tables
9
Possible solution
10
Demo
11
Preparation
12
Last Name
13
Database Migration
14
Remove Mirroring
15
Historian Mode
16
Questions
17
How can I do readonly secondary update statistics
18
How can I run old cardinality on readonly databases
19
Microsoft improve the way that the log is being sent
20
You dont need to configure
21
Firewall
22
Secondaries
23
Connections
24
Routes
25
Conclusion
Description:
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.

Curious Cases of Availability Groups

PASS Data Community Summit
Add to list
0:00 / 0:00