17.10 - Examples: Simple Rules - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Release Date
July 2021
Content Type
Administration
User Guide
Publication ID
B035-1197-171K
Language
English (United States)
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