• Teradata Workload Management

    Keeping Pace with Growing Business & User Demands

    Managing your production environment brings change & challenge as the data in your Teradata system becomes more critical to your business

  • Meeting your business needs

    Give the Highest Priority to Important Tactical Work

    Everybody wants to run queries on your database at the same time - from the boardroom to the loading dock, from marketing to front-line customer service - and they all want answers as close to real-time as possible. Teradata Workload Management prioritizes the work as per your specifications and assigns resources to make sure everything gets done on time to meet business demands.

    Automated Database Workload Management

    Because there's no such thing as a "typical day" when it comes to your data warehouse, Teradata Workload Management automatically manages resources during peak periods. This maximizes utilization of resources and ensures that the most important workload gets done first, and it lets you set priorities.

    Maximize Use of Database Resources & Reduce TCO

    Your DBAs need a dynamic, adaptable solution to cope with changing demands and use limited capacity wisely. Teradata Workload Management gives your DBAs the tools to keep pace with increasingly complex workloads and make the most of your existing data warehouse server capacity without adding expansion costs.


    Teradata Workload Management is a portfolio of products designed to manage data warehouse appliances and active data warehouses. This portfolio can:

    • Analyze current workloads and recommend workload definitions to best meet business needs
    • Monitor database requests before and during execution to ensure data warehouse resources are used efficiently
    • Adapt the workload mix dynamically to ensure high throughput and fast response times as workload conditions change
    • Visualize current and long-term trends as workloads evolve

    Workload Analyzer

    Teradata Workload Analyzer is the first step in optimizing any data warehouse. It collects system usage information from the database logs and system tables, analyzes the historical system use, and delivers reports and graphical results. With this information, DBAs can produce high-quality workload definitions that control the system resources. Workload definitions specify which users, queries, and tasks fall into which workload category. Each workload definition can contain priorities, limits on the amount of CPU time, disk I/O limits, and the number of concurrent tasks allowed within that category.

    Teradata Workload Analyzer helps DBAs fully understand the normal workloads, peak surges, and abnormal workloads on the system in multiple time periods so they can design the correct workload definitions. Not only does this ensure higher throughput and satisfied business users, it also ensures you only add more server capacity when you really need it.

    Learn More

    Workload Management Portlets

    Teradata Workload Management Portlets enable administrators to set up, manage, model, and monitor their mixed workload environment using highly interactive and customizable portlets. These portlets provide a huge improvement in the way administrators interact with and manage a mixed workload environment. Here are a few examples of the new portlets. The portlets are:

    • Workload Designer – enables the administrator to setup the workload definitions and priorities
    • Workload Monitor – provides a complete end-to-end view of the mixed workload performance
    • Workload Health – displays a list view of all workload definitions and the status of service level goal.

    Learn More

    Teradata Workload Management

    Starting with Teradata 14 for SLES11 Teradata offering included the following: 

    • Teradata Integrated Workload Management (IWM) is bundled with all Teradata platform.
    • Teradata Active System Management (TASM) is an add-on product available for EDW customers (5xxx, and 6xxx)

    Teradata Workload Management for Developers

    Teradata Integrated Workload Management

    Teradata Integrated Workload Management (IWM) offers proven and sophisticated workload management features:

    • Workload Definitions – for grouping similar queries
    • Workload Exceptions – for defining exceptions and actions
    • Workload Prioritization – for prioritizing the workload
    • Throttles – for controlling the flow of the work into the system
    • System Filters – for blocking specific type of work based on predefined criteria

    Learn More

    Teradata Active System Management (TASM)

    Teradata Active System Management (TASM) is an add-on product for your EDW (5xxx, and 6xxx) that offers additional advanced workload management capabilities suitable for mixed workload environments, including:

    •  SLG Tiers Workload Prioritization – for prioritizing the workload based on service-level goals
    •  State Matrix – for defining normal and unexpected operating periods

    Learn More
  • "Teradata brought in very knowledgeable consultants and kept them here for the duration. Teradata’s emphasis on involving Hallmark’s personnel throughout the process was instrumental to our now being self-sufficient."

    Ken Dale

    Database Administrator, Hallmark


    Hallmark Benefits from Workload Management

    In addition to 40,000 retail outlets in 100 countries, Hallmark owns the Crayola Corporation and has its own cable TV channel. When it was time to consolidate Hallmark's data warehouses, Teradata’s Professional Services Team recognized that workload management capabilities would be crucial to Hallmark’s consolidation efforts. It’s relatively easy to put two hardware systems together – it’s a much harder task to put a consolidated system in place that balances and satisfies the needs all business users. 

    Teradata Workload Management helped Hallmark’s data warehouse handle strategic analysis while providing quick response to informational requests that drive daily operations. Advanced workload management techniques helped establish priorities for both query types and set business rules to deliver service availability and predictable performance.


  • Our industry customers

    View More
  • How can we help?

    Contact us for insights and answers to your questions.

    Contact Teradata
  • Forum2


    A digital community of technical experts sharing ideas, code, best practices & lessons

    View More
  • Social Feeds