DWHPro Insights

Administration

Throttles in Teradata Workload Management: Usage, Request and Session Limits Popular

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

What are Throttles used for in Teradata Workload Management? Throttles restrict concurrent sessions, requests, or utilities to safeguard vital resources, such as CPU, memory, and AMP worker tasks, from depletion. Their implementation in Teradata workload management minimizes contention for resources on highly concurrent systems, thus bolstering overall system performance. Throttling Requests Throttle queue order, exemptions …

Read more

Maximizing Utility Job Performance with Teradata DBQL Utility Log Popular

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

To gain a comprehensive insight into the operation and performance of your load utilities and DSA jobs, the DBQLogTbl offers a starting point. The DBQLogTbl provides metrics for these utilities, but they are not as accurate or plentiful as those provided by Teradata DBQLUtilityTbl. What is the Teradata DBQL Utility Log? The DBQLUtilityTbl offers a …

Read more

Teradata Viewpoint: Diagnose Slow and Waiting Queries Most read

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

What is Teradata Viewpoint? Teradata Viewpoint is a browser-based monitoring and administration interface built from portlets. For query diagnosis, its value is connecting a late report to a session, its current state and the evidence needed for the next investigation. Available systems, portlets and actions depend on your installation and assigned roles. Worked example: investigate …

Read more

Track and Optimize Query Performance with Teradata DBQLOGTBL System Table Popular

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

Teradata DBQLOGTBL is a system table in the Teradata database management system that stores log data for requests captured by configured DBQL rules. It is a valuable resource for tracking and analyzing query performance, as it contains information about the resources used by each query and the duration of the query. DBQLOGTBL is located in …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam