Teradata Active System Management - Advanced SQL Engine - Teradata Database

Database Introduction

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
jiv1600056352873.ditamap
dita:ditavalPath
jiv1600056352873.ditaval
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata Vantage™
Teradata Active System Management (TASM) is a set of products, including system tables and logs, that interact with each other and a common data source. It facilitates automation in the following four key areas of system management:
  • Workload management
  • Performance tuning
  • Capacity planning
  • Performance monitoring

With careful planning, TASM can improve and optimize your workload management and performance. It can also improve response times and ensure more consistent response times for critical work. This can reduce the effort required by DBAs.

Some Key TASM Products and Components

The following table describes some of the key products and components of TASM.

Product / Component Description
Teradata Viewpoint A product that enables users to:
  • Create rules for filtering, throttling, and defining classes of queries (workload definitions)
  • Create events to monitor system resources
Open APIs An interface, invoked from any application, that provides an SQL interface to PMPC through User-Defined Functions (UDFs) and external stored procedures.

See Workload Management Application Programming Interface.

Query Bands A set of name-value pairs that are defined by the user or middle-tier application. Query Bands allow the user to tag session or transactions with an ID through an SQL interface.

For specific information on Query Bands, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184 and Teradata Vantage™ - Database Administration, B035-1093.

Resource Usage Monitor Data collection subsystem that includes TASM-related data collection. See Resource Usage Monitoring.