Converting Priority Scheduler Settings to Workloads - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
sef1527114222310.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. In the Existing PSA Setting dialog box, click Convert. The Migrated TASM Settings tab appears.


    Notice that the dialog box provides the following new workload definition information:
    • RP Weight
    • AG Name
    • Enforcement Priority
    • AG Weight
    • Relative Weight
    • Previous Relative
    • Workload Name
    • Classify Criteria

    By default, the conversion maps the PDSet as is. However, if you select Simplified Structure, DWM maps the PDSet such that the default RP is not used for requests even if the original PDSet did so. Instead, DWM creates a new RP for the work from the Default RP, reserving the Default RP for system work. A tactical partition is created for short-running, high-priority tactical queries, and the Standard partition runs the remaining work.

  2. After selecting either Remap As Is or Simplified Structure, click Continue to complete the conversion.
  3. Click Cancel to exit the dialog box.
  4. In the Parameters window, click View CPU Distribution. This prompts Teradata WA to group accounts into workloads and displays the PSA to DWM Conversion - CPU Distribution dialog box.


    The fields and controls on this dialog box are described in the table below.

    Option Description
    Log Option Select the appropriate log from these options:
    • DBQL (default)
    • External DBQL

      External DBQL contains DBQL data which has been copied to a database other than DBC. Its table schema can be identical to DBQL, but for improved performance Teradata recommends that DBQL data be copied to a history database defined according to Professional Services guidelines. See Database Administration (B035-1093).

    Database The database being analyzed.
    Date Range Enter the starting and ending dates of the range of the data collected. The displayed date format depends on the regional settings of the PC. To select a date from a calendar pop-up window, click the drop-down arrow. The default start date is a month prior to the current system date; the default end date is the current system date.
    Time Window Enter the starting and ending times of the range in HH format, using a 24-hour clock. Alternatively, click the drop-down arrow to select an hour from the list. The default Start Hour is 00 (12:00 A.M.) and the default End Hour is 23 (11:00 P.M.).
    Teradata WA includes all of the specified End Hour in its analysis. For example, End Hour 23 means analyze DBQL data up to and including 23:59:59.99.
    OpEnv Select the period. Click to populate the list with all available periods. The default is Always.
    Top N Value This value indicates the number of the most resource-intensive workloads to analyze. For example, 3 analyzes the three most resource-intensive workloads running (10 is the default).
    View CPU Distribution Calculates CPU distribution of workloads.
    Save Rule Set Saves the current rule set.
  5. Select Rule Set > Calculate All WD SLGs. A progress bar appears while Teradata WA determines the service level goal recommendations. These appear in the SLG Recommendations pane.