Zabbix Mssql Failed To Fetch Info Data -or No Data For 30m- !free! Online

UserParameter=mssql.connections,echo "SELECT cntr_value FROM sys.dm_os_performance_counters WHERE object_name='SQLServer:General Statistics' AND counter_name='User Connections'" | tsql -S localhost -U zabbix -P pass -D master -o /tmp/out -q Or better (Windows):

Azure SQL Managed Instance does not support sys.dm_os_performance_counters – it raises “Invalid object name”. zabbix mssql failed to fetch info data -or no data for 30m-

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. UserParameter=mssql

Start SQL Browser and ensure Windows Firewall allows UDP 1434 inbound. Part 3: Step-by-Step Diagnosis (From Zabbix Server to SQL) When the error strikes, follow this A→Z workflow. Step 1: Is the Zabbix Agent Reachable? From the Zabbix server CLI: Part 3: Step-by-Step Diagnosis (From Zabbix Server to

odbc: SQLDriverConnect: retcode=-1 (timeout expired) Increase Timeout=30 in zabbix_agentd.conf and restart the agent. Also add ODBCPoolSize=50 if using ODBC pooling. 7. The SQL Browser Service is Stopped (For Named Instances) Zabbix’s ODBC DSN often uses Server=localhost\INSTANCE . This requires SQL Browser (UDP port 1434) to resolve the dynamic port. If SQL Browser is disabled, the connection hangs then fails.

StartAgents=32 Timeout=30 ODBCPoolSize=100 EnableRemoteCommands=1 Restart the agent. Also, spread items across multiple items or use a Zabbix proxy for distributed SQL monitoring. Part 5: Prevention – Build a Resilient Zabbix-MSSQL Setup 1. Create a Dedicated Zabbix SQL Login with Minimal Permissions CREATE LOGIN zabbix_svc WITH PASSWORD = 'StrongPwd!'; CREATE USER zabbix_svc FOR LOGIN zabbix_svc; GRANT VIEW SERVER STATE TO zabbix_svc; GRANT VIEW ANY DATABASE TO zabbix_svc; GRANT CONNECT SQL TO zabbix_svc; Do not use sa or sysadmin – it’s a security risk and often blocked by compliance. 2. Use a Test Script That Emulates Zabbix Before adding the host to Zabbix, run this PowerShell script to validate all metrics: