Hitachi

JP1 Version 11 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


List of alarms

The alarms defined in a PFM - RM for Microsoft SQL Server monitoring template are summarized in an alarm table called PFM RM SQL Template Alarms 11.50. Here, 11.50 indicates an alarm table version. This alarm table is stored in the RM SQLServer folder that is displayed on the Alarms window of PFM - Web Console. The following table describes the alarms defined in the monitoring template.

Table 4‒1: List of alarms (monitoring template)

Alarm name

What is monitored

Blocked Sessions

Number of sessions that are waiting for lock releases by other sessions.

Cache Usage

Rate at which the desired data was found inside the data cache instead of being read from a disk

CPU Usage

Top 10 sessions that are currently using the largest numbers of CPU cycles

This alarm cannot be used.

Database Space

Space usage in each database in Microsoft SQL Server

Log Space Usage

Top 10 databases that are consuming the largest amounts of log space

Network Error

Impact of Microsoft SQL Server on network

Server Status

Availability of the Microsoft SQL Server instance

Note

When PFM - RM for Microsoft SQL Server does not connect to the monitoring target Microsoft SQL Server, PFM - RM for Microsoft SQL Server does not detect any alarms except Server Status.