1.3.7 Network load
Network load affects the performance of the Microsoft SQL Server. To monitor network load, use the Network Error alarm in the monitoring template provided by PFM - RM for Microsoft SQL Server. The Network Error alarm enables you to monitor how Microsoft SQL Server operation affects the network.
The following table explains the Network Error alarm in the monitoring template:
|
Alarm name |
Record used |
Field used |
Abnormal condition |
Warning condition |
Values measured |
|---|---|---|---|---|---|
|
Network Error |
PD |
Pkt Errors |
Pkt Errors > 2 |
Pkt Errors > 0 |
The Microsoft SQL Server might significantly increase network load. |
- Diagnosis:
-
If the value of the Network Error alarm exceeds 2, the Microsoft SQL Server might significantly increase network load.
- Prescription:
-
Modify network access to the Microsoft SQL Server or the system configuration related to the network.