Application Queries Overview - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem

The Application Queries portlet enables you to view key information about the queries submitted by applications, based on the historical DBQL data in Analytics Database. You can review application queries designated as suspect based on thresholds set by a Viewpoint Administrator. You can view key metrics for any date for which query log data has been collected and retained by Viewpoint for the applications you have access to, 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, specific to an application and application version.

You can only see data in the Application Queries portlet if the optional query logging (DBQL) feature has been enabled in Analytics Database. The Application Queries portlet displays all queries that have been logged for the applications you have access to.

The Application Queries 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.