Creating a New Workload For Use from Rule Set - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Teradata Workload Analyzer
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Creating a New Workload For Use from Rule Set

To create a new workload for use

1 Select Rule Set > Save to Database.

The Save Rule Set dialog box is displayed.

2 Enter a name for the rule set or accept the default name.

3 Click OK to save the new workload for use.

Note: The TDWM database is locked as a rule set is saved.

To group accounts, applications, users, or profiles into a workload

1 Select Rule Set > Workloads > New Workload. See the following table for more information about the Rule Set menu.


Menu option

Sub menu option


Save to Database


Saves the rule set to the TDWM database.

Note: The TDWM database is locked as a rule set is saved.


New Workload

Adds a new workload to the Candidate Workload Report window.


Merge Workloads

Merges selected workloads into a single workload.


Split workload

Splits the selected workload into one or more workloads.


Calculate SLGs

Calculates the service level goals for the selected workload.


Delete Workload

Deletes a workload from the Candidate Workload Report window.

Workload to AG Mapping


Performs the workload definition to allocation group mapping

Calculate All WDs SLGs


Calculates service level goals for all defined workloads.

Note: The Rule Set menu is available when the Candidate Workload Report window is open.

2 From the Add Workload dialog box, complete the options as appropriate for the new workload. See the following table.





The name of the workload.


A description of the workload.

Enforcement Priority

  • Tactical - short queries with a fixed response-time requirement.
  • Priority - important queries that should get extra resources.
  • Normal - normal queries; this is the default.
  • Background - low-priority queries with no response time requirement.
  • 3 Click OK.

    The newly created workload now displays in the Workloads Report section of the Candidate Workload Report window.