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

Plugins.MSSQL.Sessions.<connString>.QueryTimeout = 30

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 returns $null , the service account cannot read DMVs. zabbix mssql failed to fetch info data -or no data for 30m-

Then, at 10:03 AM, she saw it. Not an alarm. Not a siren. An absence.

odbc: SQLExecDirect: retcode=-1 (42S02: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'sys.dm_os_performance_counters'.) Plugins

Sometimes, it’s not an error. A development SQL Server with no active databases, no user connections, and auto_close = ON will show zero for User Connections and Batch Requests/sec – resulting in “no data for 30m” because the trend function expects a positive delta.

recovery_expression: | last(/MSSQL_Template/ms.sql.fetch_success)=1 and min(/MSSQL_Template/ms.sql.fetch_success, 5m)=1 If this returns $null , the service account cannot read DMVs

: Zabbix needs to read from the msdb database for job status:%%MAGIT_PARSER_PROTECT%% sql USE msdb; GRANT SELECT ON dbo.sysjobs TO zabbix; GRANT SELECT ON dbo.sysjobservers TO zabbix; GRANT SELECT ON dbo.sysjobactivity TO zabbix; GRANT EXECUTE ON dbo.agent_datetime TO zabbix; %%MAGIT_PARSER_PROTECT%% 3. Agent 2 Plugin Configuration