I’ve grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It’s a fairly human look at what’s involved in sailing on a Trident missile submarine…
SQL Sentry is a pretty cool monitoring system but there’s a downside to having so many knobs to turn:
it’s next to impossible to find out which knobs have been turned. Let’s look at an example.
First I built a five replica multi-subnet Availability Group using my PowerShell module OftenOn. Then
I’ve manually installed SentryOne and watched all the replicas while splitting them between two sites;
Seattle and Dallas. I could only get an evaluation license which covers one replica so the rest are not
being actively monitored but that’s not important at the moment.