Example: Prioritizing Tactical Queries and Defining Their SLGs - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
Suppose a grocery store chain wants to give personalized coupons. At checkout, the customers slide their rewards cards. The database is queried for suitable coupons, and the results need to return within one second. You want to set the SLG to have a response time of no more than one second, 98 percent of the time.
  1. Select a ruleset to edit.
    1. Open the Workload Designer portlet and the Workload Designer view.
    2. From the For System list, select PROD1.
    3. In the local Working section, click the ruleset name, SLG.
  2. Create a workload.
    1. From the ruleset toolbar, click Workloads.
    2. Next to Workloads, click .
    3. In the General tab, enter a name for the workload, in this case Store Rewards.
    4. Under Workload Management Method, select Tactical.
    5. Click Save.
  3. Add classification criteria to limit the rule to the Store Rewards application, that submits the queries to the Teradata Database system.
    1. Click the Classification tab.
    2. From the Add Classification Criteria list, select Request Source.
    3. Click Add.
      The Edit Request Source Criteria dialog box appears.
    4. From the Source Type list, select Application.
    5. Under Application, enter the name of the application that queries the database: StoreRewards_Application
    6. Click Include.
    7. Click OK.
    8. Click Save.
  4. Define the service-level goals.
    1. Click the Service Level Goals tab.
    2. Under Default Settings, select Response Time Goal.
    3. In the Response Time field, enter 1 for a response time goal of maximum 1 second.
    4. In the Service Percent field, enter 98.
      This means the response time goal is met at least 98% of the time.
    5. Click Save.
  5. Activate the ruleset.
    1. Go back to the Workload Designer view.
    2. For the SLG ruleset, click and select Make Active.
  6. [Optional] Review requests that missed the SLG criteria you defined.
    1. Open the Workload Monitor portlet.
    2. In the Dynamic Pipes View, hover over the Store Rewards workload in the workload pane.
      An information balloon appears, showing the percentage of requests that missed the SLG.

    3. For more details, click the name of the workload.
      The Workload Details View appears, providing details about, for example, request arrivals and completions.