Ccm sql server cache hit ratio (percent) – IBM NETCOOL 4.3-W User Manual

Page 241

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