Skip to navigation, content
Managing your production environment brings change & challenge as the data in your Teradata system becomes more critical to your business
Give the Highest Priority to Important Tactical Work
Automated Database Workload Management
Maximize Use of Database Resources & Reduce TCO
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.
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.
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 increaslingly complex workloads and make the most of your existing data warehouse server capacity without adding expansion costs.
Workload Management Portlets
Teradata Workload Management is a portfolio of products designed to manage data warehouse appliances and active data warehouses. This portfolio can:
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.
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:
Teradata Workload Management
Teradata Integrated Workload Management
Teradata Active System Management
Starting with Teradata 14 for SLES11 Teradata offering included the following:
Teradata Integrated Workload Management (IWM) offers proven and sophisticated workload management features:
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:
Database Administrator, Hallmark
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.
Expert insight & best practices plus real-world success stories
Contact us for insights and answers to your questions.
A digital community of technical experts sharing ideas, code, best practices & lessons