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 219: SQL Server Inventory
Episode 218: File Growths
Episode 217: A Little Something About A Few Things
Episode 216: EDI vs ETL
Episode 215: Azure Data Factory
Episode 213: New Goals for 2021
Episode 212: 10 Things You Need to Know About Data Security
Episode 211: Solorigate
Episode 210: The Elephant in the Room
Episode 209: Career Ready: Advice to New Graduates
Episode 208: SQL Server and Graph Data
Episode 207: SQL Trail 2020 Retrospective
Episode 206: .NET Core Interactions with SQL Server
Episode 205: Data Modeling for Power BI
Episode 204: IoT in Azure
Episode 203: Spark in Action
Episode 202: Virtual Conferences
Episode 201: Common Data Model
Episode 200: Anything but the Cowboys . . .
Episode 199: Technical Debt
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