SQL Server Always On Availability Groups 101
I got a few AG-related questions at https://pollgab.com/room/brento so I did an Office Hours discussion specifically focused on them. Here's what we covered: 00:00 Start 00:24 Paul Hunter: My company decided to move to AZURE. The person in charge of moving the SQL Server decided to put up an AG (I voiced my concerns over management of an AG). Now I am going to be in charge of managing an AG. Do you have any advice on how to quickly learn to manage an AG? 30:14 Bandhu: What's the max number of DB's you would not exceed for a single AG? 33:59 Dopinder: What is the top issue you see with clients running SQL Server AG? 35:29 Bandhu: Is there a good way to determine which databases a given app connects to (for the purpose of designing AG's)?
▶︎
Office Hours: Ask Me Anything About Azure SQL DB and SQL Server
▶︎
DBA Fundamentals: Corruption: Checking for Corruption
▶︎
A Distributed Availability Groups Primer
▶︎
How to Tune Queries Fast
▶︎
Bad Parameter Sniffing - what is it, and what can you do about it?
▶︎
"But It Worked in Development!" - 3 Hard SQL Server Performance Problems
▶︎
Deadlocks: Lets Do One, Understand It, and Fix It
▶︎
SQL Server Always On Availability Groups Tutorial | Step by Step Install & Failover Cluster
▶︎
Office Hours: Abrupt Intro Edition
▶︎
DBA Fundamentals - Backups 3 - Setting Up Maintenance Plans
▶︎
Senior DBA Class Triaging Failures in Availability Groups
▶︎
Troubleshoot common Availability Group cluster issues
▶︎
What To Do When SQL Server is Slow Brent Ozar
▶︎
START YOUR TUESDAY WITH FAITH | TODAY GOD IS GIVING YOU UNEXPECTED OPPORTUNITIES | FATHER FREDDY ...
▶︎
Always ON Availability Groups in SQL server - A HA-DR Solution || Ms SQL
▶︎
Senior DBA Class High Availability and Disaster Recovery Part 1
▶︎
Something is jamming GPS over Europe. Here's what we found
▶︎
Always on Availability group (AG) cluster in SQL Server
▶︎
Identifying and Fixing Parameter Sniffing Issues
▶︎