Creating and Editing a Workload - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem
You can group queries that share characteristics into a workload for an Aster system so that a set of workload management controls can be applied to the group.

Service classes are an attribute you assign to each workload to control query prioritization. Consider creating service classes prior to starting this procedure so you can specify the service class when you create a workload.

WD-Default is the default workload that is applied to queries not classified into a specific workload. If you edit the default workload, you can change the service class, but not the predicate.

  1. Edit or create a ruleset.
  2. From the ruleset toolbar, click Workloads.
  3. Next to Workloads, click .
  4. Enter a name.
    The workload is enabled by default.
  5. Create a WHERE clause and select attributes from the list for the workload predicate.
    When specifying the predicate, you can use existing UDFs, SQL operators, workload management attributes, and AND and OR conjunctions.
  6. Specify a service class.
  7. Click Save.
  8. [Optional] Set the evaluation order for workloads.
  9. [Optional] Create services classes for workloads.
    After you create service classes, consider editing existing workloads to apply those service classes.