Spotlight on SQL Server 10.0.3 - Getting Started Guide

Chat now with support

Spotlight on SQL Server and Firewalls Permissions Unable to collect data Enabling Performance Data WMI Issues Spotlight on SQL Server and Windows domains Session Trace Errors Unable to establish a Spotlight connection to a SQL Server instance Connection Issues Monitor Multiple SQL Server Instances Spotlight Diagnostic User Groups Maintenance

Back Up Spotlight Configuration Data

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 this alarm is current, you should look at the Processes page on the 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.

Tip: You can configure this alarm to ignore certain values. See "Configure an Alarm to Ignore Certain Values" (page 1) for more information.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Spotlight on SQL Server 10.0.3 - Getting Started Guide

CPU - Individual CPU Usage Alarm