Zabbix Mssql Failed To Fetch Info Data -or No Data For 30m- [hot]

The db.odbc.select query may return more than 65535 characters. To prevent the JSON from being truncated, which breaks preprocessing, split the master query into smaller parts. Filter the data on the database side using WHERE clauses, or distribute the load across several items.

tail -f /var/log/zabbix/zabbix_server.log | grep -i "mssql\|odbc\|failed\|no data"

: If your server uses a self-signed certificate, you may need to include TrustServerCertificate=Yes in your odbc.ini or connection string to prevent handshake failures.

The errors “Failed to fetch info data” and “No data for 30m” are not Zabbix bugs – they are symptoms of a broken contract between your monitoring tool and your database. By systematically checking ODBC drivers, service account permissions, instance names, and localization, you can restore full visibility. zabbix mssql failed to fetch info data -or no data for 30m-

Now that you have a working ODBC connection, configure the Zabbix frontend. Navigate to , select your MS SQL Server host, go to the Macros tab, and add or modify the following inherited macros:

To streamline your efforts, follow this checklist in order:

Here is an example Zabbix item configuration for monitoring an MSSQL database: The db

Every 3 hours, “Failed to fetch info data” for 5 minutes, then auto-recovered.

nodata(/YourHost/perf_instance["SQLServer:Databases(_Total)\Data File(s) Size (KB)",_Total],30m)=1

Ensure the DSN uses if you want to avoid storing passwords. Then leave $MSSQL.USER empty. tail -f /var/log/zabbix/zabbix_server

When the Zabbix MSSQL by ODBC or MSSQL by Zabbix agent template is used, Zabbix expects regular check-ins (e.g., every 5 minutes). If the server returns empty data, crashes, or times out, the nodata() function in Zabbix triggers this alert after 30 minutes of silence. Incorrect ODBC credentials or permissions.

The "Failed to fetch info data" error typically occurs when Zabbix is unable to retrieve data from the MSSQL database, while the "No data for 30m" error indicates that Zabbix has not received any data from the database for the past 30 minutes. Both errors can be caused by a variety of factors, including:

What do you see when testing the connection via isql or the Zabbix "Test" item button? Share public link