Defining DBQL Inputs - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-10-13
dita:mapPath
awa1488824663126.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. Do one of the following:
    • Click in the Workload Analyzer toolbar.
    • Select Analysis > New Workload Recommendations.
    • Press Ctrl+W .
    The Define DBQL Inputs dialog box appears.


  2. Fill in the fields as described in the following table.
    Option Description
    Log Option Select the appropriate log from these options:
    • DBQL (this is the default)
    • External DBQL

      Click to load the database choices into the selection box, then select the database.

      External DBQL contains DBQL data that 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).

    Date Range In the appropriate boxes, enter the starting date (From) and ending date (To) 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 end date is one day prior to the current system date; the default start date is one week (7 days) prior to the default end date.
    Time Select this option to specify a time window of less than 24 hours.

    In the appropriate boxes, enter the starting and ending times of the range in HH:MM:SS format, using a 24-hour clock. The default start time is 00:00:00 (12:00 A.M.) and the default end time is 23:59:59 (11:59:59 P.M.).

    To select a time that spans midnight, select a start time greater than the end time from the Time of Day box.

    Teradata WA includes all of the specified end time in its analysis. For example, an end time of 23:59:59 means analyze DBQL data up to and including 23:59:59.99.
    Top N Filter Select this option to filter the returned data.
    Top N Value Enter a value indicating the number of the most resource-intensive workloads to analyze. For example, enter 3 to analyze the three most resource-intensive workloads running (10 is the default).
    For better performance, implement an external historical copy of DBQL data using Professional Services guidelines and definitions, and use the same external database for workload analysis.
    Filter within Range Select this option to filter the returned data by days of the week and times of day. When selected, the Every Day and 24 Hours checkboxes become enabled and selected.
    Every Day When the Filter within Range check box is selected as described in the previous row of this table, the Every Day check box becomes enabled and selected. If left in that condition, returned data will be captured in the database every day of the week.

    Clear the Every Day check box to select specific days of the week to exclude from data capture.

    When the Every Day check box is cleared, all options in the Day of Week pane are enabled and selected. Clear one or more of the check boxes for options Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, and Saturday to exclude data capture on those days of the week.

    24 Hours When the Filter within Range check box is selected as described earlier in this table, the 24 Hours check box becomes enabled and selected. If left in that condition, returned data will be captured in the database 24 hours per day for each day selected for capture as specified by the Every Day option.

    Clear the 24 Hours check box to specify a time window of less than 24 hours during which data will be captured.

    In the appropriate boxes under Time of Day, enter the start time (From) and end time (To) in HH:MM:SS format, using a 24-hour clock. The default start time is 00:00:00 (12:00 A.M.) and the default end time is 23:59:59 (11:59:59 P.M.).

    To select a time spanning midnight, specify the start time as greater than the end time.

    Teradata WA includes all of the specified end time in its analysis. For example, an end time of 23:59:59 means analyze DBQL data up to and including 23:59:59.99.
    Category Select the appropriate category from these options:
    • Account String – Select this option to classify queries based on the account string of the user submitting the workload; this is the default.
    • Users – Select this option to classify queries based on the username submitting the workload.
    • Applications – Select this option to classify queries based on the application that is submitting the workload.
    • Profile – Select this option to classify queries based on the profile attached with the user.
  3. After specifying the options, click OK. Teradata WA queries the DBQL. The query process may take several minutes. The Candidate Workload Report window appears.
    Candidate Workload Report displays CPU, IO, and Query Volume Statistics



    The Distribution Charts tab shows the same information in a pie chart with a legend pop-up window.