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 09.00. Here, 09.00 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 nameWhat is monitored
Blocked SessionsNumber of sessions that are waiting for lock releases by other sessions.
Cache UsageRate at which the desired data was found inside the data cache instead of being read from a disk
CPU UsageTop 10 sessions that are currently using the largest numbers of CPU cycles
Database SpaceSpace usage in each database in Microsoft SQL Server
Log Space UsageTop 10 databases that are consuming the largest amounts of log space
Network ErrorImpact of Microsoft SQL Server on network
Server StatusAvailability 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.