Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference

[Contents][Glossary][Index][Back][Next]

Cache Usage

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 Product RM SQLServer
Message text Cache hit %CVS%
Enable alarm Selected
Evaluate all data Not selected
Monitoring time range Always
Alarm when damping conditions are satisfied Not selected
Interval --
Maximum occurrences --
Actions E-mail --
Command --
SNMP Abnormal, Warning, Normal
Conditional Expressions Record Server Overview (PI_SERV)
Field Cache Hit %
Abnormal condition Cache Hit % < 85
Warning condition Cache Hit % < 95

Legend:
--: The setting is always invalid.

Related report

Reports/RM SQLServer/Troubleshooting/Recent Past/Cache Usage