3.8 CPUUtil

Use this Knowledge Script to monitor the percentage of CPU resources used by the sqlservr, sqlagent, and sqlexec processes. This script raises an event if the CPU usage for SQL Server processes exceeds the threshold you set.

Resource Object

Microsoft SQL Server

Default Schedule

The default schedule for this script is Every 10 minutes.

Setting Parameter Values

Set the following parameters as needed:

Description

How to Set It

General Settings

Job Failure Notification

Raise event if job fails unexpectedly?

Select Yes to raise an event if the SQLServer_CPUUtil job fails unexpectedly. The default is Yes.

Event severity when job fails unexpectedly

Set the event severity level, from 1 to 40, to indicate the importance of an event that is raised when the job fails unexpectedly. The default is 5.

Additional Settings

Event Details

Event detail format

Select the format in which you want to display the event detail. You can select from HTML Table or Plain Text. The default is HTML Table.

Monitor CPU utilization

Include detail report in data point?

Select Yes to include a detail report in the data points collected for charts and reports. The default is unselected.

Event Notification

Raise event if CPU utilization for a process exceeds threshold?

Select Yes to raise an event if a process uses CPU more than the threshold. The default is Yes.

Event severity when CPU utilization for a process exceeds threshold

Set the event severity level, from 1 to 40, to indicate the importance of an event in which a process uses CPU more than the threshold. The default is 5.

Threshold- Maximum CPU utilization for a process

Specify the maximum CPU usage for a process that can be in use before an event is raised. The default is 55%.

Raise event if total CPU utilization for all the processes exceeds threshold?

Select Yes to raise an event if the total CPU usage for all the processes exceeds the threshold. The default is Yes.

Event severity when total CPU utilization for all processes exceeds threshold

Set the event severity level, from 1 to 40, to indicate the importance of an event in which the total CPU usage for all the processes exceeds the threshold. The default is 5.

Threshold- Maximum CPU utilization for all processes

Specify the maximum CPU usage for all processes that can be in use before an event is raised. The default is 90%.

Data Collection

Collect data for CPU utilization for each process?

Select Yes to collect data for charts and reports. If enabled, data collection returns the percentage of CPU utilization for a process. The default is unselected.

Collect data for CPU utilization for all processes?

Select Yes to collect data for charts and reports. If enabled, data collection returns the percentage of total CPU utilization for all process. The default is unselected.