CPUMonitor

Task Type:	Database Monitor
Configurable:	Yes
Host Dependent:	No
Schedule Dependent:	Yes

Description

The CPUMonitor monitors the database for sessions using more than a configurable percentage of available CPU resources.

Configuration

The <CpuMonitorConfig> element is configured with the following attribute:

Attribute	Required	Description
THRESHOLD	No	Specifies a threshold of CPU usage, expressed as a percentage. An alert is generated when a session exceeds the given threshold during the sample interval. The value provided must be an integer between 1 and 99. The default value for this attribute is 80.

The default threshold may be overridden by using one or more <User> elements, which are configured with the following attributes:

Attribute	Required	Description
NAME	Yes	Specifies a username that will be monitored using an individual threshold or will be excluded from monitoring altogether.
THRESHOLD	Depends	Specifies a threshold of CPU usage, expressed as a percentage. An alert is generated when a session exceeds the given threshold during the sample interval. The value provided must be an integer between 1 and 99. The default value for this attribute is 80. This attribute is required if the EXCLUDE attribute is omitted or set to "NO".
EXCLUDE	No	May be used to indicate that the named session is excluded from monitoring. Valid values are "YES" and "NO".

Example

<CpuMonitorConfig>
  <Default THRESHOLD="20"/>
  <User NAME="JSMITH" THRESHOLD="10"/>
  <User NAME="HR" EXCLUDE="YES"/>
</CpuMonitorConfig>

In this example, TCAgent sends an when any JSMITH session consumes more than ten percent of total CPU time, or when any other session consumes more than twenty. All HR sessions are excluded from monitoring.

Usage Notes

The CpuMonitor task samples CPU utilization once per task execution and calculates CPU used per session since the previous sample. Hence, the sample interval is the same as the task schedule for CpuMonitor.