BKSahu's picture
Company:
Country:
Personal Website:
Day Job:
blog icon Recent Articles

Teradata provides advanced Workload Management capabilities through Teradata Active System Management (TASM). However, some customers are still relying on only Priority Scheduler, without TASM's added capabilities. These customers can easily move forward to TASM. This article shows how to use Teradata Workload Analyzer (TWA) to migrate existing Priority Scheduler settings into TASM.

The principle focus of query tuning is to provide reliable summary information about the data to the optimizer. This is done by collecting accurate statistics which are then stored in a synoptic data structure known as an interval histogram. The correct choice of the column and index sets on which Statistics should be collected can help the optimizer generate better query plans, dramatically improving query performance and reduce the collection overhead. It can be difficult to understand how the optimizer uses statistics as well as deciding what statistics are needed without an automated method to help. That automated method is the Teradata Statistics Wizard, which is a client-based GUI interface for obtaining statistics recommendations for particular queries or query workloads that are submitted for analysis.

Teradata Visual Explain adds another dimension to the EXPLAIN modifier by depicting the execution plans of complex SQL statements visually and simply. The graphical view of the statement is displayed as discrete steps showing the flow of data during execution.

However, Visual Explain was using QCD to captured the query execution plan steps in relation tables to generate visual explain for query diagnostic. QCD has performance issues due to the many inserts required in QCD de-normalized tables. DBS has implemented DBQL and QCD XML plan logging for TD 13.10. These enhancements provide additional capabilities to users wishing to tune queries and applications in order to achieve better performance.

For those not already familiar with the Teradata Workload Analyzer (TWA), TWA is one of the products affiliated with TASM (Teradata Active System Management). It provides guidance for the database administrator in defining the workloads for Teradata through the analysis of log data collected over a period of time and by offering recommendations on the workload definitions, classification criteria, and service level goals. It also provides a migration feature from priority scheduler.

blog icon Recent Reference

BKSahu hasn't created any reference articles.