List of alarms
The alarms defined in a PFM - Agent for Microsoft SQL Server monitoring template are summarized in an alarm table called PFM SQL Template Alarms 12.50. Here, 12.50 indicates an alarm table version. This alarm table is stored in the SQL folder that is displayed on the Alarms window of PFM - Web Console. The following table describes the alarms defined in the monitoring template.
Alarm name |
What is monitored |
---|---|
Number of sessions that are waiting for lock releases by other sessions. |
|
Rate at which the desired data was found inside the data cache instead of being read from a disk |
|
Top 10 sessions that are currently using the largest numbers of CPU cycles This alarm cannot be used. |
|
Space usage in each database in Microsoft SQL Server |
|
Top 10 databases that are consuming the largest amounts of log space |
|
Impact of Microsoft SQL Server on network |
|
Availability of the Microsoft SQL Server instance |
- Note:
-
Since the scan may occur by SQL statement that PFM - Agent 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.