High CPU usage

Comments are closed
How can we help?
< All Topics
Print

High CPU usage

To query the Performance Store database for servers with a CPU usage greater than or equal to 95 %, use:

select s.*
from dbo.v_servers s
where s.cpu_usage >= 95

CPU usage is available on the Overview 1 dashboard:

CPU time information for each query is availabe in the following dashboards:

An alert is thrown if the CPU usage is greater than or equal to 95 3 times within 10 minutes.

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents