Teradata Workload Analyzer - Teradata Tools and Utilities

Teradata Tools and Utilities Release Definition

Product
Teradata Tools and Utilities
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2029
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata Workload Analyzer

Teradata Workload Analyzer helps DBAs identify classes of queries (workloads) and provides recommendations on workload definitions and operating rules to ensure that database performance meets Service Level Goals (SLGs). When DBAs can control resource allocations, they are better able to ensure satisfactory response times for critical queries. Teradata Workload Analyzer helps DBAs effectively manage distribution of resources using graphical displays, such as the following:

  • Distribution graphs showing resources distribution for workload queries
  • Histograms showing actual service levels, along with recommended settings
  • In addition, Teradata Workload Analyzer supports the conversion of existing Priority Definitions (PDs) sets into new workloads. This is helpful for users of earlier versions of Teradata Priority Scheduler Administrator, who created PD sets to control allocation and consumption of system resources.