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 | -- | |
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 |
Related report
Reports/RM SQLServer/Troubleshooting/Recent Past/Cache Usage