SQL Cluster Alerting

On 12/21/2017 at 4:50 PM, Justin said:

Ryan,

I have a group for cluster nodes, and clusters. I add in the clusters using their DNS name so even if it fails over to another node, it still shows as up. I then apply the property ClusterNode to the nodes and WindowsCluster to the cluster name. I have modified the datasources for monitoring windows cluster resources, groups, and nodes to only apply to devices with the category of WindowsCluster. On my groups, I disable all datasources that may be duplicated between them This works perfectly for all clustering, exchange and sql, but not for Always-On clusters as services need to be running on both sides. To correct this, I manually add the sql monitoring to each of the nodes.

This may sound a little confusing, but it was pretty straightforward to setup. Happy to help if this sounds like what you are looking for. It does cost an extra device per cluster though...

And to this note: 'It does cost an extra device per cluster though...'

Monitoring say a 2 node Windows Server File Cluster = 4 devices
- Node1
- Node2
- Failover Cluster Name
- Clustered Resource Name (File Server, SQL, etc)