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 Log Space Usage alarm monitors the top 10 databases that are consuming the largest amounts of log space.
Main settings
| Alarm properties in PFM - Web Console | Setting | |
|---|---|---|
| Item | Detailed item | |
| Main | Product | RM SQLServer |
| Message text | Log %CVS% used | |
| 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 | Transaction Log Overview (PI_TLOG) |
| Field | Log Space Used % | |
| Abnormal condition | Log Space Used % > 90 | |
| Warning condition | Log Space Used % > 80 | |
Related report
Reports/RM SQLServer/Troubleshooting/Real-Time/Log Space Usage - Top 10 Databases
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.