Changing the Priority of a Query or Session - 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
For Teradata Database systems, you can change the priority of a query or session to allow higher priority queries to run or balance session resources.

This option is only available when workloads are not enabled and the system being monitored supports this feature.

  1. From the Viewpoint Dashboard, do any of the following:
    Option Description
    Queries filtered by state
    1. Click any state in the Queries state filter bar.

      The query results that display are filtered based on what you selected.

    2. Click the row in the table for the session you want to see.
    Top 5 queries
    1. Click any row under Top 5 Queries.
    The query details view appears.
  2. Click to the right of the session number and select Change Priority.
  3. Log in to Teradata Database, if prompted.
  4. Click Next.
  5. Do one of the following to change the priority of sessions:
    • Select an account string from the list of accounts that have been assigned to the user.
    • Type an account string.
  6. [Optional] Select the check box to use the account string as the default for the selected session.
    The priority will be changed for the selected query and all subsequent queries in the current session.
  7. Click Next.
  8. Click Next to confirm your selection.