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 CPU Usage alarm monitors the top 10 sessions that are currently using the largest numbers of CPU cycles.
Main settings
| Alarm properties in PFM - Web Console | Setting | |
|---|---|---|
| Item | Detailed item | |
| Main | Product | RM SQLServer |
| Message text | CPU busy %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 | Global Server Summary (PI) |
| Field | CPU % | |
| Abnormal condition | CPU % > 90 | |
| Warning condition | CPU % > 80 | |
Related report
Reports/RM SQLServer/Troubleshooting/Real-Time/CPU Usage - Top 10 Sessions
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.