Zabbix Trigger Expression

Look for specific SQL error codes (e.g., SQL_ERROR or HYT00 = timeout).

zabbix_get -s <MSSQL_HOST_IP> -k "mssql.db.size[<DatabaseName>]"

Ensure your Zabbix monitoring user (e.g., zbx_monitor ) has the necessary permissions. Run these T-SQL commands on the target SQL Server: Zabbixhttps://www.zabbix.com Microsoft SQL monitoring and integration with Zabbix

On the Zabbix Server, run:

  • type: Regular expression parameters: ['^(.+)$', '\1', 'OK']
  • type: JavaScript parameters: | function(value) return (value && value.includes('ERROR')) ? 0 : 1;

Step 3: Verify MSSQL Configuration

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

Zabbix Trigger Expression

Look for specific SQL error codes (e.g., SQL_ERROR or HYT00 = timeout).

zabbix_get -s <MSSQL_HOST_IP> -k "mssql.db.size[<DatabaseName>]"

Ensure your Zabbix monitoring user (e.g., zbx_monitor ) has the necessary permissions. Run these T-SQL commands on the target SQL Server: Zabbixhttps://www.zabbix.com Microsoft SQL monitoring and integration with Zabbix

On the Zabbix Server, run:

Step 3: Verify MSSQL Configuration