15.00 - Recommended Monitoring Activities - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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.

  • Use the Priority Scheduler utility.
  • Priority Scheduler monitor output information shows comparative CPU usage across Priority Scheduler groups. This monitor output should be collected daily, minimally at a 5 or 10-minute interval, then summarized or charted. See Utilities: Volume 2 (L-Z) for more information about the Priority Scheduler utility.

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