16.10 - About Performance Management Setup - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Published
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)
Last Update
2018-04-26

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

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 Resource Usage Macros and Tables.

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.

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:

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