Query Monitor Overview | Teradata Viewpoint - Query Monitor Overview - 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

The Query Monitor portlet allows you to view information about queries running in Teradata Database and Teradata Aster systems as well as in Teradata Machine Learning Engine and Teradata QueryGrid so you can target problem queries.

For Teradata Database, you can see the progress of submitted queries and target longer-running queries so you can optimize them. After you have identified a problem query, you can take action to correct the problem by changing the priority or workload, releasing the query, or aborting the query or session. You can take these actions for a single query or session, or multiple queries or sessions at a time. The session view provides a table listing the sessions, account strings, users, or utilities running on the database.

From the Settings view for Teradata Database systems, you can choose to display the top sessions graph and format SQL, and set the criteria values used to display sessions in the My Criteria view and Skewed AMP views. The My Criteria session list displays only sessions that have exceeded the defined thresholds.

For Teradata Aster, you can see the progress of queries. The session view provides a table listing the sessions, databases, and users running on the database. From the Settings view for Teradata Aster systems, you can choose to display the sessions list and state filter bar.

For Teradata Machine Learning Engine, you can see the progress of queries. The session view provides a table listing the users.

For Teradata QueryGrid queries, you can see information about the progress and status of Teradata QueryGrid requests. You can see details and a visualization of the query's progress in the Details View for Teradata QueryGrid.

If JWT integration with Vantage is enabled (versions 16.50.05.00 and later), you will not be prompted to log in. A Disconnect option is not available. You cannot enter alternate credentials.
Support for TASM ARM is available for Advanced SQL Engine versions 17.10 and later.