Chapter 7: Collection Formulas
Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.3-W 219
CCM SQL Server Cache Hit ratio (percent)Type
SNMP (collection)
Description
The buffer cache hit ratio. The percentage of time that a requested data page was found in the data cache instead
of being read from disk.
Syntax
Dim I0 AS Integer Default * NAME Sql;
V1=OIDVAL(mssqlSrvInfoCacheHitRatio.%I0);
Sum(*, %V1)
Generic Database Alias
None.
Formula Editor Path
AP > Specific > SNMP > VOIP > Cisco > CCM Server > Sql Server
MIB
MSSQL-MIB.my