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

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
17.00
Published
September 2019
Language
English (United States)
Restricted Access
TTU-17.00-EAP
Last Update
2019-06-07
dita:mapPath
vjd1544831946946.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2514
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.
    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.
    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 options as appropriate to analyze the workload (described in the following table).
    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.
    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.

    Example of Report with QueryBand Name

    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.

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

    Use the Graph tab 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.