Performance Management Setup | Teradata Vantage - Performance Management Setup - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
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 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™ - Analytics Database 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.