SLES 11 Adjusting Tactical Workload Exceptions - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem
In SLES 11, when you create a tactical workload, a tactical exception is automatically created to prevent a high-consuming query from depriving tactical workloads of system resources. Tactical exceptions cannot be deleted, but you can modify them if your environment has different needs.

Tactical exceptions occur when both threshold criteria are exceeded for either Tactical CPU Time or Tactical I/O Physical Byte. Tactical exceptions trigger an action that moves a high-consuming query to another workload and can trigger other actions, such as issuing an alert or running a program. Tactical exceptions apply to the tactical workloads they are associated with, across all environments.

  1. From the ruleset toolbar, click Workloads.
  2. Select or create a tactical workload.
  3. Click the Tactical Exception tab.
  4. Under Criteria, enter thresholds for Tactical CPU Time and Tactical I/O Physical Byte.
  5. Under Action, select a workload.
    The query is moved to this workload when a query exceeds both Tactical CPU Time and Tactical I/O Physical Byte thresholds.
  6. [Optional] Under Notifications, enable any of the following options for the start or the end of the event:
    Notification Description
    Notify Database User Sends an email alert to database user when the query stops. This option is available if you have selected only Abort/Abort Selects from actions.
    Send Alert Specifies the action to trigger.
    Run Program Specifies the Alerts registered programs to trigger.
    Post to QTable The string you enter is posted to the QTable.
  7. Click Save.