1.0 - Query Monitoring - Teradata Vantage

Teradata® Vantage User Guide

Teradata Vantage
January 2019
User Guide

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).