In a scenario where both SQLSERVER and NTPERF probes were configured to collect and compare the values for BUFFER_CACHE_HIT_RATIO" SQL metric, you can see a big discrepancy between the values:
This is caused by the query used by SQLSERVER probe to fetch the values from SQL server.
sqlserver probe 5.42 and earlier
Please contact the Broadcom Support Team, and open a support case to request the sqlserver_5.42T4 probe version.
After deploying this probe version, the metric values will appear very closer on each other:
ATTENTION: If you have configured any one of the following variables in the buf_cachehit_ratio checkpoint message, they will not be resolved:
This is because this new probe version uses a new query to fetch the values, from where these variables were removed. So, to avoid this problem, you can the sqlserver.cfg and remove them (take a backup first), as below: