Monitoring MS SQL Cluster on windows with Zabbix

The goal is to monitor an active/passive cluster of MS SQL server in Zabbix We will try to use a minimalist approach.

1. Install Zabbix on all nodes

Configure each zabbix agent as active and passive

2. Declare each hosts and add a windows template on them

This will enable basic monitoring on each hosts. Use an active Windows template, so that the agent will send its data to Zabbix.

3. Create another host for the cluster

Use a passive MS SQL Template, and declare the VIP/Cluster DNS, so that Zabbix will go fetch its information directly on the active node.

This way, each node is monitored, and the active node has MS SQL Monitoring enabled.

Written on May 21, 2015