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

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	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.