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 76: Availability Group Improvements
Episode 75 Storage Testing
Episode 74: 2016 Year in Review
Episode 73: Performance Tuning
Episode 72: Test Automation in BI
Episode 71: BI Tools of the Trade
Episode 70 SQL Server on Linux
Episode 69: Our SQL Server Setup Checklist
Episode 68: SSIS Administration
Episode 67 Dear Developer
Episode 66: Microsoft's Professional Program
Episode 65: Do you have good data architecture?
Episode 64: Certifications and Career Development
Episode 63: New Data AvailabilityFeatures in SQL Server 2016
Episode 62: Ask Me Anything--Cortana Intelligence Suite
Episode 61: The Debrief
Episode 60: What is U-SQL?
Episode 59: Mirroring, Availability Groups, Replication, and Log shipping
Episode 58: 4 ways to stay sharp with technical learning
Episode 57: What SQL Server feature would you change?
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast