1.1 - Query Monitoring - Teradata Vantage

Teradata Vantage™ User Guide

Teradata Vantage
May 2020
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 Advanced 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 Vantage™ - Database Administration, B035-1093.

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