Performance Management Setup | Teradata Vantage - 17.00 - 17.05 - About Performance Management Setup - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Advanced SQL Engine
Teradata Database
Release Number
June 2020
English (United States)
Last Update

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 Vantage 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:
  • Managing Space: Operational DBAs.
  • “Working with System-Level Space Allocation” in Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.
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.