Course Description
This course delivers students the chance to optimize implementation of a Teradata Vantage Advanced SQL Engine system using the Teradata Active System Management tool (TASM). Simulating a mixed workload environment, learners apply various workload managing rules to meet a set of defined service percentage & throughput service level goals.
During this hands-on training, learners will execute Mixed Workload simulations, analyze the results, then utilize Workload Designer to apply diverse TASM rules, such as, Filters & Throttles.
Prerequisites
To get the maximum out of this training, one should have the following knowledge or experience.
- Preface to the Teradata Database
- Teradata SQL
- Teradata Physical Database Design
- Teradata Physical Database Tuning
- Teradata Parallel Transporter
- Teradata Database Administration
Target Audience
This course is developed for Teradata Associates, Customers, and Partners who have less experience with the TASM tool and require technical information about how to optimize system performance through workload management.
Learning Objectives
Upon accomplishment of this course, learners will be able to:
- Use the State Matrix to detect & adapt to environmental changes
- Control user sessions & utilities
- Utilize Filters to dynamically control and restrict access
- Utilize Throttles to dynamically control the number of queries & utilities
- Comprehend and defining workloads
- Understand & using Priority Scheduler to control CPU & I/O resources
- Dynamically manage the allocation of resources to workloads & being able to adapt those resources to altering environmental conditions
Content Outline
- Workload Management Overview
- Case Study
- Viewpoint Configuration
- Viewpoint Portlets
- Teradata Workload Analyzer – Part 1
- Establishing a Baseline
- Monitoring Portlets
- Workload Designer – General Settings
- Workload Designer – State Matrix
- Workload Designer – Classifications
- Workload Designer – Session Control
- Workload Designer – Filters
- Workload Designer – Throttles
- Workload Designer – Workloads
- Teradata Workload Analyzer – Part 2
- Workload Designer – Mapping and Priority
- Summary and Migration
FAQs
To attend the training session you should have an operational Desktops or Laptops with required specification along with good internet connection to access the labs.
We would always recommend you to attend the live session to practice & clarify the doubts instantly and get more value from your investment. However, due to some contingency if you have to skip the class Radiant Techlearning would help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.
Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant’s hand-on-practice.
Participants can easily access these labs over Cloud with the help of remote desktop connection.
Radiant virtual labs provide you the flexibility to learn from anywhere in the world and in any time zone.
The learners will be enthralled as we engage them in real world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and you will gain better experience. These real time projects, they will help you a lot in your future tasks and assignments.