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
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
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.