1.0 - Query Monitoring - Teradata Vantage

Teradata® Vantage User Guide

Product
Teradata Vantage
Release Number
1.0
Published
January 2019
Language
English (United States)
Last Update
2020-03-11
dita:mapPath
hfp1506029122470.ditamap
dita:ditavalPath
hfp1506029122470.ditaval

Query monitoring enables administrators to measure computer resource utilization by individual query. Resource utilization is modeled on a per-analytic query basis. When a query takes a long time to complete, query monitoring provides insights as to why. It is useful to identify expensive phases of a query that tax certain resources or skew work distribution.

The resource utilization data that is collected is stored in tables in Teradata SQL Engine using the existing QueryGrid™ Remote Connector mechanism and is accessible using Teradata Studio or Database Query Logging (DBQL).

For information about Teradata Studio, see Teradata® Studio™ User Guide, B035-2041. For information about DBQL, see Teradata® Database Administration , B035-1093 .

Query monitoring reports only Teradata ML Engine resource utilization while Teradata Vantage queries are running and is best suited to measuring long-running queries (several seconds to hours).