MemoryMonitor

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

Description

The MemoryMonitor monitors the database for sessions using more than a configurable percentage of available memory.

Configuration

The <MemoryMonitorConfig> element may contain one <Default> element, which is configured with the following attributes:

Attribute	Required	Description
THRESHOLD	No	Specifies a threshold of memory usage, expressed in bytes. An alert is generated when a session exceeds the given threshold. The value provided must be a positive integer. The default value for this attribute is 500000000.
INCREMENT	No	When memory usage for a session exceeds the given threshold a new threshold is calculated by adding the INCREMENT value to the THRESHOLD value. Should the same session exceed the new threshold another alert is generated and the threshold value is incremented again. If TCAgent determines that the memory usage for a session drops below a recalculated threshold, the threshold is reduced by the increment specified. The threshold will never drop below the initial threshold provided.

When no <Default> element is provided, the value used for THRESHOLD is 500000000 and the value used for INCREMENT is 50000000.

The default threshold and increment values 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 different threshold and increment values, or will be excluded from monitoring altogether.
THRESHOLD	Depends	Usage is the same as described for the <Default> element; see above. The increment value, however, applies only to the session named in the element. This attribute is required if the EXCLUDE attribute is omitted or set to "NO".
INCREMENT	No	Usage is the same as described for the <Default> element; see above. The increment value, however, applies only to the session named in the element.
EXCLUDE	No	May be used to indicate that the named session is excluded from monitoring. Valid values are "YES" and "NO".

Example

<MemoryMonitorConfig>
  <Default THRESHOLD="16000000" INCREMENT="1000000"/>
  <User NAME="HR" THRESHOLD="32000000"/>
  <User NAME="BJONES" EXCLUDE="YES"/>
</MemoryMonitorConfig>

In this example, TCAgent sends an alert when any session uses more than 16M of memory, or when any HR session uses more than 32M of memory. When any session exceeds its given threshold, a new session threshold is calcuated by increasing the previous threshold by 1M. All BJONES sessions are excluded from monitoring.