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

Teradata Workload Analyzer User Guide

prodname
Teradata Workload Analyzer
vrm_release
15.10
category
User Guide
featnum
B035-2514-035K

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.

1 Select Rule Set > Workloads > New Workload.

See the following table for more information about the Rule Set menu.

 

Menu option

Sub menu option

Description

Save to Database

 

Saves the rule set to the TDWM database.

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

Workloads

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.

 

Option

Description

Name

The name of the workload.

Description

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.