17.00 - Examples: Simple Rules - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

prodname
Advanced SQL Engine
Teradata Workload Management
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1197-170K
Rule Name Attributes Current State
Filter Financial_Tbl Non-Finance users are not allowed to access Financial_Tbl Enabled
Throttle DaveFields Session limit on user DaveFields Enabled limit = 3
WD Tactical Classify by Single-AMP into a Workload Definition (WD) Enabled
WD Short Classify by Est Time < 10 seconds into a Workload Definition Enabled
WD Long Classify by Est Time > or equal to 10 seconds into a Workload Definition Enabled
WD Queries Classify by Account = Finance into a Workload Definition

Exception if CPU skew > or equal to 20

Exception action: Change to WD Long

Throttle 10 concurrent

Enabled

Exception Disk Ratio If CPU Disk Ratio > 10

Action: Abort on SELECT

No workloads qualify