DWHPro Insights

Administration

The Teradata AMP Worker Task Widely read

Icon of a chrome hammer inside an orange circle over a brick pattern

Introduction to the Teradata AMP Worker Task The Teradata AMP Worker Task or AWT is the heart of the AMP, responsible for executing tasks and ensuring the smooth functioning of the system. AWTs are threads that process incoming tasks in the AMP. Each AMP has a finite pool of AWTs, which is shared among all …

Read more

Understanding Teradata DBQL Tables and Query Logging Most read

Illustration of a person in a suit standing beside a database cylinder

Learn about Query Logging with Teradata DBQL Tables, a powerful feature for workload analysis and performance tuning. Configure settings and select which key figures to store and their level of detail. The article covers how to implement and activate DBQL tables, determine which information to collect, and analyze tactical queries.

Understanding Teradata Flow Control Mode for Efficient Workflow Management Popular

Illustration of a person in a suit standing beside a database cylinder

Introduction Teradata efficiently manages complex workflows by distributing and expanding processes across numerous AMPs. However, when an AMP’s maximum capacity is reached, it can initiate flow control mode. This blog post delves into Teradata’s Flow Control Mode, its impact on performance, and effective monitoring and management strategies. How It Works Teradata’s decentralized architecture distributes workload …

Read more

Understanding Deadlocks in Teradata: Prevention and Handling Strategies Widely read

Illustration of a person in a suit standing beside a database cylinder

What are Deadlocks in Teradata? Deadlocks arise when two transactions hold locks on database objects required by the other transaction. Here is an example of a deadlock: Transaction 1 locks some rows in Table 1, and transaction 2 locks some rows in Table 2. The next step of transaction 1 is to lock rows in table 2, and …

Read more

How to Migrate a Teradata Virtual Machine from VMware to Proxmox Popular

Illustration of a person in a suit standing beside a database cylinder

This article outlines the procedure for migrating the Teradata virtual machine image from VMware to a level 1 hypervisor. This historical workflow concerns a Teradata virtual machine image. Confirm current image availability, guest support and hypervisor compatibility in the vendor documentation. To run Teradata virtual machine on a different server, you must install the operating …

Read more

Tracking Teradata Statistics Usage with StatUseCountV Popular

Illustration of a person in a suit standing beside a database cylinder

How to find out if the Teradata Statistics we created for a specific workload are used? Teradata statistics greatly affect SQL query efficiency. We need a reliable method to get this information. Various objects, such as tables and join indexes, can have statistics collected on them. As performance tuners, it is important to confirm their …

Read more

Teradata Rollbacks: Understanding the Impact on Performance and How to Avoid Them Popular

Illustration of a person in a suit standing beside a database cylinder

How to Abort the Teradata Rollback Rollback cancellation can invalidate the table and is a DBA recovery action, not routine tuning. Follow a documented recovery procedure and verify a rebuild/restore path; skew on one AMP does not inevitably stop the entire system. Watch: what happens when you abort a big DELETE This video shows why …

Read more

Maximize Your Teradata Compression Potential with DWHPRO TITHONIZER

Illustration of a person in a suit standing beside a database cylinder

Do you work in an environment where a Teradata compression tool is installed that conforms to your satisfaction? If not, I assume you are probably not very pleased with having to walk through the databases, table by table, to find out what to compress on which column. Typically, this is time-consuming, fatiguing, and subject to …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam