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