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.