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 nameRecord usedField usedAbnormal conditionWarning conditionValues measured
Network ErrorPDPkt ErrorsPkt Errors > 2Pkt Errors > 0The 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.