Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


Cache Usage

Organization of this page

Overview

The Cache Usage alarm monitors the rate at which the desired data was found inside the data cache and did not need to be read from a disk.

Main settings

Alarm properties in PFM - Web Console

Setting

Item

Detailed item

Main Information

Product

RM SQLServer(7.0)

Alarm message

Cache hit %CVS%

Enable alarm

Selected

Alarm notification

Notify when the state changed

Notification target

State changes for the alarm

Evaluate all data

Not selected

Monitoring time range

Always

Report alarm when the following damping condition is reached

Not selected

occurrence(s) during

--

interval(s)

--

Alarm Conditions

Record

Server Overview (PI_SERV)

Field

Cache Hit %

Abnormal condition

Cache Hit % < 85

Warning condition

Cache Hit % < 95

Actions

E-mail

--

Command

--

SNMP

Abnormal, Warning, Normal

Legend:

--: The setting is always invalid.

Related report

Reports/RM SQLServer/Troubleshooting/Recent Past/Cache Usage (6.0)