DB team requires query/ calculations that will be giving the output for monitoring alerts for two check points in sqlserver probes below
Release : 9.x/ 20.x
Component : UIM - SQLSERVER 5.42 HF3
After the queries are run below calculation is used by the probe to calculate the actual data for the mentioned checkpoints
Check the Additional section for queries used by sql server probe
CheckPoints:- BufferCacheHitRatio
If version is > = SQL Server 2012
BufferCacheHitRatio = QoS Data
if version < SQL Server 2012
if ((page_lookups > 0) && (page_lookups >(page_reads + page_writes)))
hit_ratio = ((page_lookups - (page_reads + page_writes)) / page_lookups) *100;
else
hit_ratio = 100;
QoS Data = hit_ratio
Checkpoints:- Transactions
For all the version:-
if(time > 0 )
count_sec = count/time
else
count_sec = 0
QoS Data = count_sec
UIM - Multiple queries related to checkpoint for sql server probe
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=200626