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

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem

The Query Monitor portlet allows you to view information about queries running in the relevant system so you can target problem queries.

For Teradata systems, 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 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 Aster systems, 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 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 SQL Engine versions 17.10 and later.