One of the newer features in SQL Server is availability groups, which can help solve a number of business problems. As administrators, availability groups introduce some complexity as we are tasked to make sure the Recovery Point Objective (RPO) and Recovery Time Objective (RTO) can be meet for these servers. The complexity comes because we have different instances that must work together, but they don't always see eye to eye. In this episode, we chat with Tracy Boggiano of channeladvisor about how they go about monitoring their availability groups and the pros and cons of the out of the box tools. Our discussion touches on process of the availability group process and Tracy has posted her scripts on her bog for you use as you look at reviewing your environments. I think you will enjoy this discussion.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/06/29/episode-102-monitoring-availability-groups/ and have fun on the SQL trail.
Episode 139: Getting Started with SQL Server in Azure
Episode 138: Meeting of the Minds
Episode 137: You want to work with Analytics?
Episode 136: Devops with Visual Studio
Episode 135: Seinfeld Episode
Episode 134: CosmosDB
Episode 133: Shrinking Files
Episode 132: What technologists can learn from superheroes
Episode 131: Big Data Solutions in the Cloud
Episode 130: Use Case for PowerShell
Episode 129: Graph Databases
Episode 128: Database Doing DevOps
Episode 127: Developing in the database
Episode 126: SQLSaturday Edition
Episode 125: You must be an engineer
Episode 124: Beyond the runbook; DR Organization
Episode 123: Top 5 things to know when getting admin access
Episode 122: Isolation Levels
Episode 121: What makes a good manager?
Episode 120: SQL Injection
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
Lex Fridman Podcast
The Unbelivable Truth - Series 1 - 26 including specials and pilot