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...
20 hours ago, 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...
Thanks @Justin - Great feedback and commentary!