Query Groups - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
fey1467302953244.ditamap
dita:ditavalPath
2206_User_vp_1600_NEW.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

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.