Hi,
I am trying to monitor one of our SQL EXPRESS Server with the MSSQL Zabbix Agent2 Template and encountered issue with some of the items.
I have try manually to retrieve the metrics with SQL query:
SELECT * FROM sys.dm_os_performance_counters WHERE instance_name = 'BOne';
I got no results.
So I have disable the AUTO_CLOSE option, then I got some of the counters with readings, but still nothing in Zabbix
Error:
Preprocessing failed for: [{"object_name":"MSSQL$SQLEXPRESS
atabases","cntr_value":0,"counter_name":"State","i nstance_name...
1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log Growths')].cntr_value.first()": no data matches the specified path
From looking around the forum I have seen other people got this issue, some fix it with correcting counter names, and some with changing the name of the instance with new Macro.
In my case the instance is same as in the original template. The Logs counter are written the same (even case sensitive)
Any other idea what else I can debug to find the cause?
I guess its or something not configured in my end or mis match between the template and my instance.
Thank you!
I am trying to monitor one of our SQL EXPRESS Server with the MSSQL Zabbix Agent2 Template and encountered issue with some of the items.
SELECT * FROM sys.dm_os_performance_counters WHERE instance_name = 'BOne';
I got no results.
So I have disable the AUTO_CLOSE option, then I got some of the counters with readings, but still nothing in Zabbix
Error:
Preprocessing failed for: [{"object_name":"MSSQL$SQLEXPRESS
atabases","cntr_value":0,"counter_name":"State","i nstance_name...1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log Growths')].cntr_value.first()": no data matches the specified path
From looking around the forum I have seen other people got this issue, some fix it with correcting counter names, and some with changing the name of the instance with new Macro.
In my case the instance is same as in the original template. The Logs counter are written the same (even case sensitive)
Any other idea what else I can debug to find the cause?
I guess its or something not configured in my end or mis match between the template and my instance.
Thank you!
Comment