Before diving into the troubleshooting steps, it's essential to understand the possible causes of these errors. Some common causes include:
Once the command-line test works, you can proceed to configure Zabbix.
#!/bin/bash
mssql.custom.query[Server=.;Trusted_Connection=True;,SELECT cntr_value FROM sys.dm_os_performance_counters WHERE object_name='SQLServer:Buffer Manager' AND counter_name='Buffer cache hit ratio']
21 Sept 2023 — PiotrJ. Junior Member. Joined: May 2023. Posts: 26. Problem: MSSQL: Failed to fetch info data (or no data for 30m) 21-09-2023, 19: zabbix mssql failed to fetch info data -or no data for 30m-
"An answer," Tom said quietly. "The query is SELECT COUNT(*) FROM transactions WHERE timestamp > DATEADD(minute, -5, GETUTCDATE()) . It should return in milliseconds. But the execution plan shows a table scan on a table with 2.3 billion rows."
The monitoring user must have VIEW SERVER STATE (for SQL 2017/2019) or VIEW SERVER PERFORMANCE STATE (for SQL 2022). Before diving into the troubleshooting steps, it's essential
Look for entries containing mssql or odbc . Common errors include: