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

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

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

"action_name": "MSSQL Fetch Failure Alert", "conditions": "trigger_name": "MSSQL: Failed to fetch info data OR no data for 30m", "trigger_severity": ["high", "disaster"] , "operations": "default_subject": "CRITICAL: MSSQL data fetch failed on HOST.NAME", "default_message": "Problem started at EVENT.TIME on EVENT.DATE\n Problem name: TRIGGER.NAME\n Host: HOST.NAME\n Severity: TRIGGER.SEVERITY\n\n Original event ID: EVENT.ID\n Check MSSQL connectivity:\n 1. Verify SQL Server is running\n 2. Check firewall rules\n 3. Validate credentials in Zabbix configuration\n 4. Review SQL error logs\n\n Last 5 fetch attempts: ITEM.VALUE<ms.sql[fetch_data],5>", "recovery_subject": "RECOVERY: MSSQL fetch restored on HOST.NAME", "recovery_message": "Problem resolved at EVENT.RECOVERY.TIME\n Duration: EVENT.DURATION\n Host: HOST.NAME"

When installing Zabbix Agent 2, the installer creates a dedicated configuration file for SQL Server called mssql.conf . By default, this file is often nested within an inactive subdirectory where Agent 2 ignores it. zabbix mssql failed to fetch info data -or no data for 30m-

Before touching configuration files, let’s decode what Zabbix is actually trying to tell you.

The most frequent cause is a simple credential mismatch. Ensure your Host Macros are correctly set: : The SQL login name. $MSSQL.PASSWORD : The corresponding password.

If this alert is active, check the following common causes identified by users in the Zabbix Community Forums : Problem: MSSQL: Failed to fetch info data (or

The customer portal, which relied on that data for a "system status" widget, showed a spinning circle. Then a dash. Then a blank page.

Remember: Use the diagnostics in this guide to enforce a 15-minute maximum data outage, and set up proactive alerts for the monitoring system itself.

When Zabbix says "failed to fetch info data," it means the agent attempted to execute a query (likely against performance counters or DMVs) and received: Verify SQL Server is running\n 2

Next, grant the necessary server-level roles and permissions:

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

Open your mssql.conf file and define your connection parameters using named sessions. This prevents you from exposing cleartext passwords across global macros:

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