The (shipped with Zabbix 6.0+) is robust when properly configured.
StartAgents=32 Timeout=30 ODBCPoolSize=100 EnableRemoteCommands=1 zabbix mssql failed to fetch info data -or no data for 30m-
Log into the machine running Zabbix Agent 2 and run the zabbix_agent2 binary with the test flag: The (shipped with Zabbix 6
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. no user connections
A widespread cause of "no data" alerts occurs when the Zabbix Agent 2 service starts up, but completely ignores the MSSQL plugin requirements because its standalone configuration file is missing from the directory structure.