1.3.3 CPU usage ratio per session
The CPU usage ratio per session may affect the performance of the Microsoft SQL Server. To monitor the CPU usage ratio per session, use the CPU Usage alarm in the monitoring template which PFM - Agent for Microsoft SQL Server provides. The CPU Usage alarm enables you to monitor the top 10 most CPU-cycle used sessions at present.
The following table explains the CPU Usage alarm in the monitoring template:
Alarm name |
Record used |
Field used |
Abnormal condition |
Warning condition |
Values measured |
---|---|---|---|---|---|
CPU Usage |
PI |
CPU % |
CPU % > 90 |
CPU % > 80 |
Microsoft SQL Server can be too busy. |
- Diagnosis:
-
If the value of CPU % field exceeds 90 %, the system can be too busy.
- Prescription:
-
Remove what makes the system too busy to lessen the system load.
For details about the CPU Usage alarm, see CPU Usage in 4. Monitoring Template.