Query Groups 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 Groups portlet allows you to view information about session queries running on a Teradata system or in Teradata QueryGrid that match defined criteria.

A query group is any combination of one or more Analytics 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 systems by opening more than one instance of the Query Groups portlet.

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