Recommended Monitoring Activities - Teradata Database

Teradata Database Design

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Recommended Monitoring Activities

A quick list of monitoring activities that offer a foundation for workload management follows:

  • Use Teradata Viewpoint to monitor and manage the workload.
  • Collect user resource usage detail data.
  • The DBC.Acctg table is the underlying table for the AMPUsage view, and captures data about user usage of CPU and I/O for each AMP. Heavy resource consumers over time, skewed work, and application usage trends can be identified.

  • Collect ResUsage data.
  • The ResUsage tables report on the aggregate effect of all user requests on various system components over time, and can identify bottlenecks and capacity issues. See Resource Usage Macros and Tables for details on all ResUsage data and macros.

  • Use the Lock Viewer Viewpoint portlet.
  • Lock Viewer is essential for identifying locking conflicts.

  • Use Database query logging (DBQL).
  • The Database Query Log records details on queries run, including arrival rates, response times, objects accessed, and SQL statements performed. See Database Administration and SQL Data Definition Language for more information about Query Logging.

  • Enable canary queries.
  • You should use canary queries with tactical query applications. See “Using Canary Queries” on page 826 for more information about this monitoring technique.