16.20 - 16.50 - Query Spotlight Overview - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.20
16.50
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-2206-071K
Language
English (United States)

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.