Zabbix Mssql Failed | To Fetch Info Data -or No Data For 30m-

This specific error in Zabbix typically triggers when the monitoring system hasn't received any data from the MSSQL instance for a prolonged period (30 minutes), often due to ODBC configuration issues or insufficient permissions for the monitoring user. Alert Message Draft

  • Increase item timeout in Zabbix (default 3s for agent; ODBC has its own). Long-running queries can cause no-data.

6. Dashboard Widget Query

-- For Zabbix dashboard to monitor fetch status
SELECT 
  h.hostid,
  h.name as host,
  i.key_,
  i.lastvalue as fetch_status,
  CASE WHEN i.lastvalue = '0' THEN 'OK' ELSE 'FAILED' END as status,
  FROM_UNIXTIME(i.lastclock) as last_check
FROM items i
JOIN hosts h ON i.hostid = h.hostid
WHERE i.key_ = 'ms.sql.fetch_success'
AND (i.lastvalue = '1' OR i.lastclock < UNIX_TIMESTAMP() - 1800)
ORDER BY i.lastclock DESC;

The error "MSSQL: Failed to fetch info data (or no data for 30m)" typically indicates a communication failure between the Zabbix server/proxy and the Microsoft SQL instance, often stemming from ODBC misconfiguration, authentication issues, or network restrictions. Key Troubleshooting Areas zabbix mssql failed to fetch info data -or no data for 30m-

Close window