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

The error "MSSQL: Failed to fetch info data (or no data for 30m)" in Zabbix typically indicates a breakdown in communication between the Zabbix monitoring component (Server, Proxy, or Agent 2) and the Microsoft SQL Server instance. This alert triggers when the primary "Get status" item, which populates dependent items with JSON data, returns an empty value or fails to execute. 1. Resolve Authentication and Permissions

The Zabbix user requires specific permissions to fetch performance data. Run the following script in SQL Server Management Studio (SSMS) to ensure the account has the necessary access: zabbix mssql failed to fetch info data -or no data for 30m-

She wrote in her post-mortem: "Zabbix did not lose the data. We lost the ability to fetch it. The silence was the alarm." The error "MSSQL: Failed to fetch info data

UserParameter=mssql.connections,powershell -Command "&  $conn=New-Object Data.Odbc.OdbcConnection('DSN=ZabbixSQL');$conn.Open();$cmd=$conn.CreateCommand();$cmd.CommandText='SELECT cntr_value FROM sys.dm_os_performance_counters WHERE object_name=''SQLServer:General Statistics'' AND counter_name=''User Connections''';$cmd.ExecuteScalar();$conn.Close() "

Signs in zabbix_agentd.log:

  • Agent and proxy status

    Restart: Always restart the Zabbix Agent 2 service after making changes to plugin configurations. Signs in zabbix_agentd

    2. Use a Test Script That Emulates Zabbix

    Before adding the host to Zabbix, run this PowerShell script to validate all metrics: