Query Monitoring

Teradata® Vantage User Guide

brand
Teradata Vantage
prodname
Teradata Vantage
vrm_release
1.0
category
User Guide
featnum
B700-4002-098K

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