Hello,
we are using Zabbix to monitor MSSQL databases via ODBC. Everything works fine, but there's one problem related with distance between Zabbix host and one of monitored databases.
There's a network delay varying from 230 to 300 ms between both and that's causing short-lasting notifications about MSSQL service unavailability. There should be Zabbix proxy closer to monitored DB, but since there's only one DB I would rather avoid setting up another host just for this DB.
Is there a way to modify the MS SQL trigger somehow to add e.g. 1 minute of delay or something like that?
MSSQL: Service is unavailable (1.png)
Will this trigger work once modified like this? (2.png)
we are using Zabbix to monitor MSSQL databases via ODBC. Everything works fine, but there's one problem related with distance between Zabbix host and one of monitored databases.
There's a network delay varying from 230 to 300 ms between both and that's causing short-lasting notifications about MSSQL service unavailability. There should be Zabbix proxy closer to monitored DB, but since there's only one DB I would rather avoid setting up another host just for this DB.
Is there a way to modify the MS SQL trigger somehow to add e.g. 1 minute of delay or something like that?
MSSQL: Service is unavailable (1.png)
Will this trigger work once modified like this? (2.png)