MSSQL by Zabbix agent 2 : mssql.cache_hit_ratio failed

[studero]

Hi all,

Configuration :
Zabbix server version : 7.0.5 on RedHat

Client Windows Server 2019
Zabbix agent version : 7.0.4 with MSSQL plugins
MSSQL version : 16

The Item mssql.cache_hit_ratio return this following error :

Preprocessing failed for: [{"object_name":"SQLServer:Plan Cache","cntr_value":3608,"counter_name":"Cache Hit Ratio","instan...
1. Failed: cannot extract value from json by path "$[?(@.counter_name=='CacheHitRatio')].cntr_value.first()": no data matches the specified path

And on the log server file :

6326:20241024:101500.564 error reason for "svw-mssql-22p:mssql.cache_hit_ratio" changed: Preprocessing failed for: [{"object_name":"SQLServer:Plan Cache","cntr_value":3792,"counter_name":"Cache Hit Ratio","instan...
1. Failed: cannot extract value from json by path "$[?(@.counter_name=='CacheHitRatio')].cntr_value.first()": no data matches the specified path

I need help to resolve this error.

Regards
Olivier

[galavichid]

studero I have similar errors but on multiple 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$SQLEXPRESSatabases","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

Do you get all the Logs values?