16.20 - 16.50 - Workload Event Type Options (TASM) - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.20
16.50
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-2206-071K
Language
English (United States)

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.