sql-server-2008zabbixserver-monitoring

Using Zabbix how to monitor database without installing agent on the host?


I want to monitor the data on Microsoft sql server database using Zabbix. for example, in table T1 containing columns col1, col2, col3, when the value of col1 is less than 0 it should notify me. Due to the security reason I cannot install agent on the database host. I want to know how can I monitor this database without installing Zabbix agent on its host?


Solution

  • You can use ODBC monitoring, described in here.

    The template already has standard items preconfigured, you must add your customizations: your item will be a SELECT statement, your trigger will react to the returned value.

    You can also find 3rd party stuff in the second tab or in Zabbix Share.