Chapter 7: Collection Formulas

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

Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.3-W

219

Page 241
Image 241
IBM 4.3-W manual CCM SQL Server Cache Hit ratio percent, MSSQL-MIB.my