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.

Diagnosis:

If the value of Availability is 0 (stopped), the Microsoft SQL Server instance might be invalid.

Prescription:

Check whether a connection to the Microsoft SQL Server can be established. If the connection cannot be established, modify the environment that communicates with Microsoft SQL Server. If you cannot identify any problems in the communication environment, check the status of the Microsoft SQL Server service.

For details about the Server Status alarm, see Server Status in 4. Monitoring Template.