Hi All,
I wondering to create an alert for SQL AlwaysOn High availability " Not Synchronization" state monitoring. Can you please help me out complete the same?
Not being funny here but there are so much lack of information in your question. What sql? mssql, mysql, postgresql......etc. Whats it installed on? windows, linux? What SW modules do you have?
In my experience the "SQL ALWAYSON" relates to MS SQL 2016 and later AlwaysOn Availability Groups (automatic DB synch between MS SQL servers/clusters). We are in a planning stage for the deployment and our SolarWinds DB and it will be the first in our environment to run in such configuration. What we are trying to achieve is site-redundant SolarWinds HA environment. We haven't gotten to the "monitoring" part of that solution yet so can't share any experience in that area.
If the Cluster templates and AppInsight for SQL isn't enough you cna do more.
I use the PowerShell commands for this occasionally, you can also use SQL queries. Here a a few links I had bookmarked for PowerShell examples.
Monitoring AlwaysOn Health with PowerShell – Part 1: Basic Cmdlet Overview – SQL Server AlwaysOn Team Blog
Monitor an AlwaysOn Availability Group with PowerShell – Hey, Scripting Guy! Blog
Can anyone package these up into a template for the masses to consume, enjoy and enhance our PR strategy for SAM?
