Query Monitor View | Teradata Viewpoint - Query Monitor View - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

The Query Monitor view shows a list of sessions running on a system and allows you to categorize the displayed sessions, such as by account string, session, user, and so on.

Selection Menus
Enables you to select the system and report that defines the sessions displayed.
Top Sessions Graph
Displays the sessions with the largest value compared with the total number of sessions currently running in a Teradata Database.
State Filter Bar
Displays a count of the sessions in each state. Click any state in the bar to change the displayed data in the summary table to show only the sessions running a query in the selected state.
Overflow Menu Displays additional states. If the number of states on the State Filter Bar exceeds the available space, you can select another state to replace the current state.
Filters
Shows only rows that match your filter criteria.
Summary Table
Displays summary information about sessions, account strings, users, or utilities in columns. The current view is configured in the Configure Columns dialog box and Settings view. The view is refreshed when new data is collected. Click a row in the table to see details.
Table Actions
For Teradata Database systems, table actions include:
  • Clear Filters removes any content in the filter boxes.
  • Configure Columns allows you to choose the columns to display and set thresholds.
  • Abort, Change Priority, Change Workload, and Release Query allow you to manage the selected queries and sessions.
  • Export creates a .csv file containing all available data. If filters are used, only filtered data is exported.
For Teradata Aster systems, table actions include:
  • Clear Filters removes any content in the filter boxes.
  • Configure Columns allows you to choose the columns to display.
  • Abort Process allows you to abort the selected non-idle process.
  • Export creates a .csv file containing all available data. If filters are used, only filtered data is exported.

For more information on Clear Filters, Configure Columns, and Export table actions, see Summary Table Controls.

For Teradata Machine Learning Engine systems, table actions include:
  • Clear Filters removes any content in the filter boxes.
  • Configure Columns allows you to choose the columns to display.
  • Export creates a .csv file containing all available data. If filters are used, only filtered data is exported.

For more information on Clear Filters, Configure Columns, and Export table actions, see Summary Table Controls.