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

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
You can group queries that share characteristics into a workload for an Teradata 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.