16.10 - Other Tools Useful for Monitoring and Managing Tactical Queries - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
User Guide
Publication ID
B035-1094-161K
Language
English (United States)

The following recommendations refer to monitoring and management facilities other than Database Query Logging or Teradata Viewpoint that might be active in a Teradata data warehouse. These recommendations are made with tactical query applications in mind; however, their value should be understood in light of the entire Teradata Database environment.

  • Avoid using the account string expansion &T variable for tactical queries, because it is likely to write one row in AmpUsage for every request issued. This extra processing overhead can impact response time and reduces the throughput of single- or few-AMP tactical queries. See Database Administration for more information about account string expansion variables.
  • Stop using Access Logging to log queries. Database Query Logging provides most of the same functionality and offers much more. DBQL also has considerably less impact on the performance of tactical query applications. See Database Administration and SQL Data Definition Language for more information about Access Logging and Query Logging.
  • Taking frequent snapshots using Priority Scheduler monitor (every 5 or 10 seconds) incurs no meaningful overhead and does not affect tactical query performance. Information from this monitor output can be useful in understanding how priorities are functioning and which groups are using what extent of CPU activity.
  • A ten-minute collection interval for ResUsage has proven sufficient in many diverse environments, and minimizes any impact on tactical queries. ResUsage data is critical to tracking overall system-level health and usage patterns, and for capacity planning. See Resource Usage Macros and Tables for more information about ResUsage.