Hey SQL Server DBAs, I've got some questions that I'm looking for data points on:
- How many primary AGs do you typically run in a given instance? Are we talking 1 or 2 or do you tend to load up primary AGs?
- Would you rather monitor your AG via the AG listener with the ability to follow in the event of a failover or register all of the instances an AG could run on and get a more complete picture (including any activity on read-only environments)?
- Would you be OK with additional overhead from duplicate monitoring with the trade-off of being able to follow the primary in the case of a failover?
Thanks in advance! Mandevil