17.10 - Other Tools Useful for Monitoring and Managing Tactical Queries - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-1094-171K
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 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 Teradata Vantage™ - Database Administration, B035-1093 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 Teradata Vantage™ - Database Administration, B035-1093 and Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184 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 Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099 for more information about ResUsage.