I don’t blog a lot about AGs. If we’re being honest (and I do try to be honest with you, dear reader), I just like performance tuning topics way more. When new features get announced for AGs, some of you may ooh and aah, but not me.
I Make A Face
I don’t make a face because I don’t like the features, or think they’re bad. I make a face because I imagine them breaking. I imagine them breaking in the middle of the night. I try to think about upgrading them.
And that, dear readers, is why this Bouncer-American picked performance tuning. I didn’t learn SQL to spend more weekend nights hanging out with people I’m inevitably going to have to yell at.
But Also This
I don’t really do much with AGs, so perhaps my fears are unfounded. Once upon a time I had a home lab set up with VMs. I had FCI VMs, Log Shipping VMs, Mirroring VMs, and AG VMs. You know what they did? Gathered dust. Most of my questions about those technologies were just kind of settled.
It’s not that I don’t pay attention! I do, really. For instance, when Microsoft released this Failover Detection Utility, I thought it was super cool.
I also pay attention to stuff that gets released in updates. Just in the release notes for 2017 CUs, I found these:
This wasn’t all of them. There were some for Linux that I skipped over, and not because I think the Linux stuff is irrelevant.
It’s just so new, I expect it to be buggier than a flophouse wig stand (sorry Bob).
So I gotta ask, how are you fine folks out there doing with your AGs?
- Are you hitting bugs?
- Are you patching regularly?
- Are you running into other issues?
- Did you pick up and run to the cloud?
If you’re patching regularly, are you using a pre-prod environment to test patches out?
I’m not saying you need one, but uh…
Thanks for reading!