Chapter 7: Collection Formulas

CCM SQL Server number of locks

Type

SNMP (collection)

Description

The total number of locks in use by SQL Server.

Syntax

Dim I0 AS Integer Default * NAME Sql;

V1=OIDVAL(mssqlSrvInfoTotalLocks.%I0);

Sum(*, %V1)

Generic Database Alias

None.

Formula Editor Path

AP > Specific > SNMP > VOIP > Cisco > CCM Server > Sql Server

MIB

MSSQL-MIB.my

224

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

Page 246
Image 246
IBM 4.3-W manual CCM SQL Server number of locks, Total number of locks in use by SQL Server