-
Problem report
-
Resolution: Unresolved
-
Trivial
-
None
-
6.0.31
-
None
There are errors with items such as:
- Buffer cache hit ratio
- Cache Hit Ratio
- Worktables From Cache Ratio
Error happens on preprocessing steps using parameter, for example
**
Code:
$[?(@.counter_name=='WorktablesFromCacheRatio')].cntr_value.first()
it fails with this message:
**
Preprocessing failed for: [{"object_name":"SQLServer:Access Methods","cntr_value":"828","counter_name":"AU cleanup batches/...
1. Failed: cannot extract value from json by path "$[?(@.counter_name=='WorktablesFromCacheRatio')].cntr_value.first()": no data matches the specified path
One can modifies preprocessing steps to:
$[?(@.counter_name=='Worktables From Cache Ratio')].cntr_value.first()
Now it get values but I think they are miscalculated: