"MSSQL: Failed to fetch info data (or no data for 30m)" typically indicates a communication or permission breakdown between Zabbix and your SQL Server
Update Zabbix Frontend:
On your MSSQL Host in the Zabbix UI, update the following Macros : $MSSQL.USER : zbx_monitor $MSSQL.PASSWORD :
Step 1: Verify Zabbix Configuration
2. The Zabbix Service Account Lacks VIEW SERVER STATE
zabbix_get -s 192.168.1.100 -k "perf_instance[\SQL2019\PROD,'SQLServer:General Statistics','User Connections']"
- Provide an exact zabbix_item key and query review if you paste it.
- Suggest specific timeout and SQL optimizations for your query.
- Draft commands for your environment (Windows vs Linux, ODBC vs agent).
- Check the database connection string and credentials used by Zabbix.
- Ensure that the database credentials are correct and have the necessary permissions.
- Verify that the database server is running and accepting connections.
“No data for 30 minutes.”