Query Monitor Overview - Teradata Workload Management - 16.20

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K

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.