Spotlight on SQL Server Enterprise 11.7 - Release Notes

CPU - Individual CPU Usage Alarm

The Windows CPU - Individual CPU Usage alarm is activated when the average CPU utilization of a single processor exceeds a threshold. This value is taken over a specific number of background collections.

Sustained high CPU utilization of a single processor on multiprocessor systems indicates that process threading may not be functioning efficiently.

When the alarm is raised

Look at the Processes page on the Windows Server | Processes Drilldown to find out which Windows process is consuming the CPU. The process:

• May not have its process affinity set correctly. (You can set this via the Windows Task Manager.)
• May not be designed for multiprocessor threading.
• May not be configured correctly.

Configuration

• You can configure this alarm to ignore certain values. For more information, see Do not alarm for certain values.