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 .