Query Log Overview - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem

The Query Log portlet enables Teradata DBAs to view key reports based on the historical DBQL data in the PDCRDATA.DBQLogTbl_Hst table in Analytics Database. If the number of DBQL rows exceeds 10 million per day, you can specify the name of a database view in the Monitored Systems portlet to load a subset of the query log data to make sure only the most important data is collected.

You can review queries designated as suspect based on thresholds set for the Query Log data collector in the Monitored Systems portlet, and access system-wide, application specific, and user specific information. You can view key metrics for any date for which query log data has been collected and retained by Viewpoint, and drill down to see details about specific queries. You can also view the trends of key performance indicators, aggregated daily or weekly and going back over a time frame from the last six months to two years.

You can only see data in the Query Log portlet if the optional query logging (DBQL) feature has been enabled in Analytics Database and the query logs are archived using PDCR. For more information, see Teradata® Database Administration.

The Query Log portlet does not participate in the rewind feature. The portlet provides a date selector to select the date of the query log information you want to view.