I'm trying to understand the best way to monitor these types of services/systems.
When a failover cluster has multiple nodes, only one of the nodes actively has the database at any given time so monitoring the agent based host for the node itself doesn't make sense with the ODBC template. Similar applies to Availability Groups.
What I am doing is creating a host in zabbix with the agent IP pointing to the IP of the SQL cluster/group, creating the DSN for that and applying the template. This way I can monitor the actual service regardless of what node is handling the workload.
Is this the correct way to do this? Am I missing anything? Or is this the right approach?
Thanks
When a failover cluster has multiple nodes, only one of the nodes actively has the database at any given time so monitoring the agent based host for the node itself doesn't make sense with the ODBC template. Similar applies to Availability Groups.
What I am doing is creating a host in zabbix with the agent IP pointing to the IP of the SQL cluster/group, creating the DSN for that and applying the template. This way I can monitor the actual service regardless of what node is handling the workload.
Is this the correct way to do this? Am I missing anything? Or is this the right approach?
Thanks