Hitachi

JP1 Version 12 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 12.50. Here, 12.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

Notes
  • 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.

  • Since the scan may occur by SQL statement that PFM - RM for Microsoft SQL Server executes, if you use the alarm table to evaluate the Full Scans field of the Server Overview (PI_SERV) record or the Full Scans/sec field of the Server Overview 2 (PI_SRV2) record, the alarm may occur.