1.3.8 Instance validity
To monitor whether a Microsoft SQL Server instance is valid, use the Server Status alarm in the monitoring template provided by PFM - Agent 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.