MSSQL Database Cluster Monitoring

[chicjo01]

NagiosXI: 5.4.12

I have an MSSQL Cluster with an active / passive setup. I wanted to see if you have advise on how to monitor this cluster so notifications for the passive server does not get sent out.

Currently, we are monitoring each server in the cluster for ping, CPU, memory, disk space, SQL agent, SQL server. The current monitors don't know if the server is in an active or passive state.

Some Background:
The MSSQL Cluster is setup to only allow the active server to have the disk drives (E, F, Q, T), SQL server and SQL agent running. This means when a fail over happens the disk drives, SQL server, and SQL agent send out notification that the services or drives are having a problem. This has caused the MSSQL DBA confusion and complaints about false alarms.

[scottwilkerson]

Most people monitor all of the servers but leave notifications off for items like these.

Then you can add them to a BPI group set the threshold you want, and then monitor the group as a whole by running the BPI wizard against the created group.

Then send notification on the group, and not the individual services in the cluster. this is adaptable to create however you like.
https://assets.nagios.com/downloads/nag ... BPI_v2.pdf

[chicjo01]

Thanks. Will give it a try.

[scottwilkerson]

Let us know if you run into any hiccups