Analyzing Workloads Based On “Who” Parameters - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities

1 In the Candidate Workload Report window, right-click over the workload to be analyzed in the Workloads Report.

The Workloads Report shortcut menu displays the menu options described in the following table.

 

Table 9: Workloads Report shortcut menu 

Option

Description

Workload Details

Displays the workload details in the Workload Attribute tabbed screen.

Analyze Workload

Analyzes the workload based on “who” or “what” parameters (second level of analysis). This will invoke the Analyze Workload window.

Merge Workload

Merges workloads.

Split Workload

Splits workloads.

Calculate SLGs

Calculates the service level goals for the selected workload.

Rename Workload

Renames the workload.

Delete Workload

Deletes the workload from the Workloads Report.

Delete Assigned Request

Removes the assigned requests from the Workload Report. The deleted items are automatically re-displayed in the Unassigned requests report. This option is available only when a detail row (not a workload aggregation row) is selected.

Calculate All WDs SLGs

Calculates SLG Goals for all defined workloads

Workload to AG Mapping

Performs WD to AG mapping (same as existing WD to AG option)

Save Report As

Saves the workloads report to a file (in either .xml, txt or html formats).

Print Report

Prints the workloads report.

Hide Details

Hides or shows the cluster details. Only workload rows are displayed when Hide is selected.

2 Select Analyze Workload.

Note: Alternatively, expand the node next to the workload to be analyzed under the Candidate Workloads tree, then select Analyze.

The Analyze Workload window appears.

3 Complete the following options as appropriate to analyze the workload as described in the following table.

Note: To display the total number of elements for correlation parameters, and the total available maximum and minimum ranges for distribution parameters, see “Configuring Application Options” on page 29.

 

Option

Description

OpEnv

Displays the system setting for the operating environment (period event). The default setting is ‘Always,’ with precedence of one. You can select one or more OpEnvs to analyze with the workload.

Syscon

Displays the system setting for the system condition. The default setting is ‘Normal,’ with severity of one as part of the new rule set. The default setting cannot be deleted. You can select one or more Syscons to analyze the workload.

Workload Correlation Parameter

Lists the available “Who” and “Where” parameters to substitute for the ones previously used. For example, if account-based parameters were used initially, this list displays application-based and object-based parameters in case they provide more efficient workloads. Click the appropriate parameter for the workload you want to refine.

Queryband Filter Name

Lists the available query band names. The query band names are automatically loaded when the Analyze Workload tab displays. The number next to each query band name represents the number of distinct value counts.

The Analyze Workload tab displays which query band the analysis is based on.

Figure 8: Example of report with query band name displayed

Load

Click to refresh the list of query bands.

Workload Distribution Parameter

Lists the available “What” and “Exception Criteria” parameters. Select the appropriate distribution parameter to view the analysis graph for the selected correlation parameter (based on queries distribution on the selected “What” and “Exception Criteria” parameter). The default distribution parameter is CPU Time. Normalized CPU Time is the default distribution parameter.

Distribution Buckets

Enter the number of histogram buckets to distribute the resulting distribution parameter values into. For example, if the correlation parameter is Client ID and the distribution parameter is CPU Time, and the bucket number is ten, then the total CPU Time value is divided into ten equal histogram buckets and the report displays how the top Client IDs are distributed among the bucket values.

The default distribution is ten histogram buckets.

Figure 9: Example of Distribution Parameters with ten buckets

Arrival Rate/Throughput

Lists the Start and End dates to analyze Arrival Rate/Throughput for the selected correlation parameter. The lists are enabled if Arrival Rate/Throughput are selected as the distribution parameter. This option is enabled when Arrival Rate or Throughput are selected as Distribution Parameters

Group By

Select the Hour option to group selected Arrival Rate/Throughput days by the hour. For example, if the Start Date is 11/20/06 and End Date is 11/23/06, the hours would be grouped as follows: zero hour from 11/20 to 11/23, first hour from 11/20 to 11/23, second hour, and so forth.

Select the Date option to group the selected days by the date of each day.

Perform Analysis

Displays the Graph tab with the selected Data Filter settings. A workload analysis report and distribution graph display.

DBQL Date Range

Displays the starting and ending date range of data collected.

Select Workload

Lists the name of the candidate workloads. Click the workload to be refined.

View Classification

Click to view the classification of the current workload displayed in the Current Workload Classification list after each level of analysis is performed.

View Exception

Click to view the exception of the current workload displayed in the Current Workload Classification list after each level of analysis is performed.

Current Workload Classification

Lists the workloads currently being classified. The number next to each workload classification represents the distinct value counts within all possible correlation parameters. For example, Account Name (3) means that there are a total of three accounts classified.

Undo Classification

Click to restore the workload to the previous classification. The workload must be selected from the Current Workload Classification list to be undone. Workload classifications may be undone more than once. Classifications added with the Add to option can be undone. First-level analyses cannot be undone.

4 Click Perform Analysis to analyze the selected workload with the chosen options.

The Analyze Workloads results are displayed with a graph.

The following options for the Graph tab are described in the following table.

 

Option

Description

Correlation Parameter option

Displays Correlation Report information in the graph.

Distribution Parameter option

Displays the Distribution Report of the correlation parameter plus distribution parameter that is displayed. For example, if CPU Time is the selected distribution parameter, then the distribution of CPU Time of the selected correlation parameter is displayed.

Workload Name

Displays the name of the current workload being viewed.

Correlation Report by

Displays the selected correlation parameter that the report is based on.

Distribution Report by

Displays the selected distribution parameter that the report is based on.

Top N Value text box

Enter the number of resource-intensive workloads to analyze. The default number is 10.

Refresh button

Redisplays the graph with the newly selected parameters.

Home button

Redisplays the Analyze Workload tab with the Data Filters tab.

Zoom In - Zoom Out

Changes the granularity of the graph view.

The Graph tab allows you to select a distribution or correlation parameter to analyze for a particular workload. For example, if the correlation parameter is ClientID, and the distribution parameter is Response Time, the analysis displays a report for the distribution of Response Time based on found ClientIDs for the selected workload.

Creating New Workloads From Groups Of Existing Workloads

1 From the Analyze Workload tab, select the Correlation Parameter option in the View By box.

2 Select one or more rows in the Analyze Workloads report with the attributes to be flagged, for example, “high CPU usage.”

3 Right-click to display the shortcut-menu.

The Analyze Workloads report shortcut-menu displays the options described in the following table.

 

Option

Description

Split to New Workload

After selecting a single row or block of rows in the Analyze Workload report, choose this option to create a new workload with all the selected classifications. The selected row is removed from the report and the graph is updated with the remaining unassigned clusters.

Add clusters for Deeper analysis

Click to add selected clusters to the current workload for deeper analysis.The selected cluster is removed from the report and the graph is updated.

Note: This option is disabled for original workloads. The Split Workload option allows for a new workload to be created. See Table 9 on page 62 for more information. The Add To option is then enabled for further workload classification.

Auto-generate Workloads

Select this option to automatically generate a new workload for each selected row.

Update Graph and Distribution Report

Select this option to update the report and redraw the graph to include changes.

Save Report As

Select this option to save report in .txt, .html, or .xls format.

4 Select Split to New Workload.

The Add Workload dialog box appears.

5 Fill in the Add Workload dialog box to describe the new workload.

6 Click Preview Classification to view the classification of the workload to be created.

A read-only Classification window displays with the classification criterion of the workload.

7 Click OK.

Teradata WA creates a new workload containing both the Criteria #1 and Criteria #2 attributes.

Creating a Separate New Workload for Each Selected Row

Teradata WA creates a new workload for each row containing the Criteria #1 and Criteria #2 attributes.

1 Select Correlation Parameter in the View By box.

2 Select one or more rows in the Analyze Workloads report with the attributes to be flagged, for example, “high CPU usage.”

3 Right-click to display the shortcut-menu.

4 Select Auto-Generate Workloads.

The Auto-Generate Workloads dialog box appears.

5 Select an option as described in the table below.

 

Option

Description

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.
  • 6 Click OK.