About Performance Management Setup - Teradata Database

Teradata Database Administration
Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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.

Note: 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 “WITH Logging Options” on page 267.

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:

  • Chapter 9: “Managing Space: Operational DBAs.”
  • “Working with System-Level Space Allocation,” in Security Administration.

    • 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 Chapter 14: “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:

  • “Setting Up Database Query Logging” on page 488.
  • Chapter 15: “Tracking Query Behavior with Database Query Logging: Operational DBAs.”
    		•

    For information on other useful tools, see Chapter 19: “Troubleshooting: Operational DBAs.”