7 years ago
SQL Cluster Alerting
Currently we are managing a customer with multiple SQL Clusters. Currently we don't have a way to effectively monitor against the cluster. LM throws alarms on the passive node in the cluster beca...
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...