16.20.16.20 - 16.20 - Workload Event Type Options (TASM) - Teradata Workload Management

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K

You can define thresholds for workload event types. When a threshold is met or exceeded, the associated workload event occurs. Maximum and minimum limits must be positive integers. The following event types are available.

Event Types Description
Active Requests Defines maximum or minimum number of queries that can be active at one time. Active Requests are not available for utility workloads.
Arrivals Defines maximum or minimum per-second arrival rate for queries. Arrivals are not available with utility workloads.
AWT Wait Time Defines minimum time a step in a request can wait to acquire an AWT.
CPU Utilization Defines maximum or minimum CPU usage for a query.
Delay Queue Depth Defines minimum number of queries in the delay queue.
Delay Queue Time Defines a minimum for the time a request can be in the delay queue.
SLG Response Time Triggers an event based on the Response Time SLG set for the workload. Available only if a Response Time SLG is set for the workload.
SLG Throughput Triggers an event based on the Throughput SLG set for the workload. Available only if a Throughput SLG is set for the workload.

Some workload event types allow you to set a qualification time. Setting qualification times can prevent very short incidents from triggering events. The qualification time is checked at the end of each interval.

Qualification Method Options Description
Simple

Specifies how long an event threshold must be met before an event is triggered.

Immediate

Specifies that an event is triggered immediately after an event threshold is met.

Averaging

Specifies the following:

  • Under Qualification Method, the time period during which the data sample is averaged.
  • Under Qualification Time, how long the rolling average of the metric value must meet the event threshold before an event is triggered.