About Performance Management Setup - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - Database Administration

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
English (United States)
Last Update
Product Category
Teradata Vantage

The following table describes set up tasks that must be completed to use the performance management techniques described elsewhere in this section.

Tool Setup Task
Resource Usage Data (ResUsage) Turn on ResUsage data collectors to enable system data gathering and provide information to various Teradata Viewpoint system management portlets.
In addition to Teradata Viewpoint, you can use ResUsage macros to examine the collected data.

For information, see Teradata Vantage™ Resource Usage Macros and Tables, B035-1099.

Lock Logging Use the WITH LOCK =n log option for the BEGIN/REPLACE QUERY LOGGING statement to log any lock contention longer than n centiseconds. The minimum acceptable value for n is 5.

You can access the DBQL lock log through the Viewpoint lock viewer portlet or query the system table DBC.DBQLXMLLOCKTbl or the view DBC.QrylockLogXMLV.

For information, see Periodic Maintenance and Performance.

Teradata Viewpoint Configure Teradata Viewpoint, the primary Teradata Database system management tool, to:
  • Monitor resource usage, query activity, workload and detect problems.
  • Set thresholds that help to identify performance problems.
  • Set up alerts to inform you when thresholds are exceeded.

For details, see the Teradata® Viewpoint User Guide, B035-2206.

Space allocation Allocate space according to best practice recommendations, including a spool space reserve. See:
Collect Statistics Collect statistics on table columns and recollect when necessary to provide the Optimizer with the information necessary to create optimal query execution plans.

See Improving Query Performance Using COLLECT STATISTICS: Application DBAs

Database Query Logging (DBQL) Set up DBQL to collect data about queries for use in query optimization and detection of bad queries. See How to Use DBQL.

For information on other useful tools, see Troubleshooting: Operational DBAs.