Query Spotlight 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 Query Spotlight portlet allows you to view completed queries that exceeded the thresholds you set. You can view individual queries of interest as a line graph over time and against a variety of metrics. The Snapshot tab displays the query data at any point in time.

Use Query Spotlight to:
  • View general information about a query.
  • Inspect a query as a line graph using the date-range slider and time marker.
  • Set a date and time in the rewind toolbar. This feature is useful for rewinding data in surrounding portlets to a point of time specified within a query. The Query Spotlight portlet can set time and date but it does not respond to changes made in the rewind toolbar.

The Settings view allows you to choose the query criteria that filter which metrics appear in the views.

You can monitor multiple systems by opening additional instances of the Query Spotlight portlet. Rewind control is given over to the last instance of Query Spotlight to use the time marker.