Changing the Priority of a Query or Session

Teradata Viewpoint User Guide

prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K
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 menu item is only available when workloads are not enabled and the system being monitored supports this feature.

  1. Click the row of the query you want to change.
  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.