SQL Server Cluster Monitoring | Product Discussions

RichB · 2022-09-05T20:44:34Z

I have a question on setting up SQL cluster monitoring. According to https://www.logicmonitor.com/support/monitoring/applications-databases/windows-server-failover-cluster-on-sql-server-monitoring the datasource Microsoft_SQLServer_FailoverClusterNodeStatus should be used in conjunction with WSFC. I have the Windows Cluster related datasources, and I have the SQL Server AlwaysOn Availability datasources as well. I’m unable to get the Microsoft_SQLServer_FailoverClusterNodeStatus to apply. The DAG meets the applies to criteria (hasCategory("WSFC_VNN") && hasCategory("MSSQL"). When I test the script I get the message “there would be no instances discovered for the selected device”. I want this datasource to monitor and alert when a SQL cluster failover has occurred. I’ve tested failover and no event is recorded specifically around this with any of the other datasources. The SQL cluster is an Active Active configuration. Am I missing a step in the configuration?

MoreDiscussions

SQL Server Cluster Monitoring | Product Discussions | LogicMonitor Community