Some MSSQL environments, 'Cache hit ratio' item becomes unavailable.

Preprocessing failed for: ...
Failed: cannot extract value from json by path ... no data matches the specified path

We checking the master item (Get performance counters), it was found that SQL queries need to be fixed.

This issue occurs due to the Collation setting of the database, which is case-sensitive.
In the case of CA_AS, Changing the letter 'base' to 'Base' will resolve the issue.

...             WHERE  counter_name = 'Cache Hit Ratio base'
↓
...             WHERE  counter_name = 'Cache Hit Ratio Base'