Zabbix Mssql Failed To Fetch Info Data -or No Data For 30m- ((full))

Zabbix nodata trigger, really a lifesaver | by Werner Dijkerman

expression_alt: | ( last(/MSSQL_Template/msql.info.fetch.status) = 1 and min(/MSSQL_Template/msql.info.fetch.status, 30m) = 1 ) or ( (now() - last(/MSSQL_Template/msql.last.success.time)) > 1800 ) zabbix mssql failed to fetch info data -or no data for 30m-

If the script takes 15 seconds to run, but the Zabbix timeout is set to 3 seconds (default), the connection is cut. Zabbix registers this as a failed fetch. If this happens repeatedly, the item goes into a "Not Supported" state for a period (often 10-30 minutes) before retrying, causing the "No data for 30m" gap. Zabbix nodata trigger, really a lifesaver | by