This review focuses on the common Zabbix alert: "MSSQL: Failed to fetch info data (or no data for 30m)."
The Zabbix alert is a critical warning indicating that your Zabbix server or agent has stopped receiving performance and health metrics from a Microsoft SQL Server instance. This issue generally stems from three specific areas: database authentication restrictions , ODBC driver configuration errors , or Zabbix Agent 2 plugin misconfigurations . Root Causes of the Failure
Use this checklist to systematically eliminate the error:
Map the explicit instance prefix to the matching host macro. Phase 1: Verify SQL Server Access & Permissions zabbix mssql failed to fetch info data -or no data for 30m-
By default, Zabbix components have a strict 3-second timeout for executing scripts and queries. On large, highly transactional, or heavily loaded MSSQL instances, gathering system information can take longer than 3 seconds, causing Zabbix to drop the connection and report "no data." You must increase this limit in your configuration files. For Zabbix Agent 2:
Plugins.MSSQL.Sessions.SQLServer1.Uri=sqlserver:// :1433 Plugins.MSSQL.Sessions.SQLServer1.User=zbx_monitor Plugins.MSSQL.Sessions.SQLServer1.Password=
$MSSQL.DSN : SQLServer1 (matching the session name in your config). This review focuses on the common Zabbix alert:
: Check that the path to the ODBC driver in /etc/odbcinst.ini is correct.
MSSQL: Failed to fetch info data (or no data for 30m) - Zabbix
From the Zabbix server or proxy:
ybcnyc. Junior Member. Joined: Jun 2022. Posts: 1. MSSQL monitoring - MSSQL: Failed to fetch info data (or no data for 30m) 16-06- Microsoft SQL monitoring and integration with Zabbix
If using Microsoft ODBC Driver 18 for Linux/Windows, encryption is on by default, leading to certificate failures if not configured correctly.
The Zabbix alert is a common and frustrating issue that database administrators and DevOps engineers encounter when setting up Microsoft SQL Server monitoring. Phase 1: Verify SQL Server Access & Permissions
If your Zabbix template uses ODBC, test the Data Source Name (DSN) using isql : isql -v Use code with caution.
Thirty minutes.