MSSQL: Failed to fetch info data (or no data for 30m) - Zabbix

If you are using the template, the MSSQL plugin must be active and configured on the target host. Microsoft SQL monitoring and integration with Zabbix

You are staring at your Zabbix dashboard, and the dreaded red indicator has appeared. The trigger message reads:

The error is a common trigger in Zabbix, signaling that the master item responsible for gathering server metrics is failing to retrieve or process information. This generally occurs when using the " MSSQL by ODBC " or "MSSQL by Zabbix agent 2" templates. Core Causes of the "No Data" Alert

For a database administrator or a monitoring engineer, this is a high-priority alert. It implies that Zabbix has lost visibility into your SQL Server instance. Is the database down? Is the network blocked? Or is it just a permissions hiccup?

Test if the Zabbix server/proxy can actually reach the database using isql from the command line:

ybcnyc. Junior Member. Joined: Jun 2022. Posts: 1. MSSQL monitoring - MSSQL: Failed to fetch info data (or no data for 30m) 16-06-

When this alert triggers, the primary data collection item (often an internal master item or a discovery rule) is returning an error or an empty value. The most common failure points include:

21 Sept 2023 — PiotrJ. Junior Member. Joined: May 2023. Posts: 26. Problem: MSSQL: Failed to fetch info data (or no data for 30m) 21-09-2023, 19:

The Zabbix Agent runs as SYSTEM (or a local user), but SQL Server restricts access to Dynamic Management Views (DMVs) like sys.dm_os_performance_counters .

Before diagnosing Zabbix, you must confirm that the ODBC layer works.

Go to , filter by the host and item. Click History (or Graph ) and see if values appear sporadically. If you see a value 30 minutes ago but nothing recent, the agent is sending but SQL intermittently returns NULL – often due to a deadlock or query timeout.

ybcnyc. Junior Member. Joined: Jun 2022. Posts: 1. MSSQL monitoring - MSSQL: Failed to fetch info data (or no data for 30m) 16-06-