To monitor whether a Microsoft SQL Server instance is valid, use the Server Status alarm in the monitoring template provided by PFM - RM for Microsoft SQL Server. The Server Status alarm enables you to monitor the validity of a Microsoft SQL Server instance.
The following table explains the Server Status alarm in the monitoring template:
Alarm name | Record used | Field used | Abnormal condition | Warning condition | Values measured |
---|---|---|---|---|---|
Server Status | PD_IA | Availability | Availability = 0 | Availability = 0 | The Microsoft SQL Server instance might be invalid. |
For details about the Server Status alarm, see Server Status in 4. Monitoring Template.