TeraTeam UK Teradata DBA Definition
TASM - Teradata Active System Management
TASM - Teradata Active System Management
TASM is a grouping of products to assist in the monitoring and management of the varying mixed workload of an active data warehouse. TASM currently consists of three products: Teradata Workload Analyzer, Teradata Dynamic Workload Manager and Teradata Manager.
Teradata Workload Analyzer taps into the database query log and system tables. It analyzes information and recommends a set of workload definitions. It also splits up resources among the various workloads and determines how they should be allocated to meet service-level goals (SLGs). You may have a workload definition for tactical queries, saying that to run these queries in three seconds or less, certain types of resources need to be applied.
Using Dynamic Workload Manager, data warehouse managers can create rules that help maintain service-level goals. If there is a workload definition that's full of longer-running queries, the data warehouse manager can input a rule that virtually states to the system, "Once you've reached 20 queries of a particular type of workload, the next one will be delayed." The result? A change in processing that results in minimal disruption despite the workload traffic. If, for example, the 21st query normally runs in one hour, and it takes an hour and five minutes, the end user probably won't be affected as much as he or she might be by query gridlock. Once the work level goes below 20, the delayed query is automatically put back into the system.
The third part is Teradata Manager which is used for real time monitoring of the Teradata Database.
Terateam UK staff were employed at Barclays Bank during one of the first and hence most mature TASM implemetations world wide, and Terateam's Paul Groves subsequently gave a well received presentation at the subsequent Technical Conference on our achievements.
