17.10 - Query Groups Overview - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Teradata Viewpoint
Teradata Workload Management
Release Number
Release Date
October 2021
Content Type
User Guide
Publication ID
English (United States)

The Query Groups portlet allows you to view information about session queries running on a Teradata Database system or in Teradata QueryGrid that match defined criteria.

A query group is any combination of one or more Teradata Database users, account strings, query bands, and workloads. For example, a query group that contains a group of users, could be configured for you to view queries based on the country of the user.

Queries appear in a group because they match certain criteria or characteristics. You can only view groups that have been assigned to you. If you identify a problem query, you can correct the problem by changing the priority or workload, releasing the query, or aborting the query or session. Take these actions for one query or session, or multiple queries or sessions at a time.

The summary view contains a table with one row allocated to each group running on the database. It contains all the information matching the criteria set for that group.

The details view contains session and query information.

The Query Groups portlet allows you to filter queries by group for all sessions. You can set thresholds for certain columns, and when the threshold is exceeded, the information is highlighted in the summary table.

The Settings view allows you to change display options.

You can monitor multiple Teradata Database systems by opening more than one instance of the Query Groups portlet.

Support for TASM ARM is available for Advanced SQL Engine versions 17.10 and later.