Teradata Active System Management

Managing your company’s production environment brings change and challenge as the data in your Teradata system become more critical to your business.

Email Print Download

 Average 2.5 out of 5

Keeping Pace with Changing, Growing User Demands

Consider the demands placed on modern data warehouses. Executives want instant response time in their dashboards. Marketing wants to run predictive analytics to develop new campaigns. Shipping wants continuously fresh data to trace shipments. The call center needs two-second queries while talking to a customer about their account. And finance needs to run complex ad-hoc reports with deep drill downs. And they all want to do these tasks at the same time.

 

Since database administrators (DBAs) don’t have unlimited data warehouse server capacity, they must use existing capacity wisely. That means managing the Teradata system for maximum throughput at all times while accommodating the demands of each organization. But giving each user community what it needs requires planning and monitoring. And since the data warehouse and user demands are constantly evolving, the DBA needs a dynamic, adaptable solution that changes with those changing demands.
Teradata is making it easier than ever to keep pace with your increasingly complex data warehouse workloads. How? With Teradata Active System Management.

Teradata Active System 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

A Suite of Support

Teradata Active System Management. products include:

EB3625_fig1

Teradata Workload Analyzer

Teradata Workload Analyzer
The Teradata Workload Analyzer (See Figure 2.) 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.

EB3625_fig2

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 Dynamic Workload Manager

Teradata Dynamic Workload Manager (DWM) analyzes each database query before and during execution based on the DBA’s workload definition rules. DWM uses thresholds – such as CPU time, I/O count, and response time – to monitor for exception conditions and adjust the priority of executing tasks dynamically. As user tasks change during the day, month, or year, DWM automatically adjusts resource allocations to maximize system throughput while achieving service level goals. If a threshold exception is detected, Teradata Dynamic Workload Manager automatically executes workload definition rules, which can be:

  • Allow the task or query to proceed.
  • Proceed, and log the task or query for further analysis.
  • Proceed, and alert the administrator or DBA via e-mail or pager.
  • Switch the task into another workload definition with a lower priority.
  • Defer the task until previous work is completed.
  • Reject the request.

Teradata DWM is different from comparable solutions because it can define workloads by table, application, users, time periods, processing time, type of statement (Select, Insert, and Join), answer set size, or type of utility (e.g., Teradata FastLoad). It also lets the DBA define exception handling for tasks that violate workload business rules. Example rules include:

  • Allow only five concurrent requests from workload MKTG.
  • On the 15th and 30th of the month between 8:00 a.m. and 3:00 p.m., prevent full table scans in database C.
  • User_Todd can run no more than 10 queries at one time.
  • Between 9:00 a.m. and 4:00 p.m., account SALES cannot have > 4 simultaneous queries in the database.

Teradata DWM also provides for event-driven changes to the workload definitions and rules being used. An event can be a quarterly financial close, a hardware failure, or a simple change from daytime to nighttime processing priorities. All of the workload priorities, rules, and resource limits can be automatically switched over to an alternate set of priorities and rules. The DBA doesn’t need to be on site or on call 24 hours per day, and the operations staff doesn’t need to use complicated procedures to rebalance system priorities. This means the Teradata system can manage itself to achieve optimum throughput under varying conditions and business objectives. This is an innovative, industry first for data warehouse systems management.

Teradata Active System Management Portlets

Teradata has replaced older client-server versions of Teradata Manager and Teradata Dynamic Workload Manager with portlets running in the Teradata Viewpoint portal. The Teradata Active System 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.

Workload Monitor

The Workload Monitor portlet gives the administrator a complete end-to-end view of a mixed workload environment. Administrators and programmers can monitor and manage queries as they pass through the system. Through this intuitive graphical application, a DBA can easily monitor the environment for anomalies, and act quickly on problems or issues. Features native to Teradata Viewpoint, such as rewind, further enhance Workload Monitor, and enable administrators to examine system activity hours or days earlier.

EB3625_fig3

Workload Health

The Workload Health portlet displays a list view of all workload definitions set up by the administrator, as well as indicating whether or not that workload has met its service level goal. Administrators and programmers can drill into a workload definition, and closely monitor metrics that will affect whether or not that workload will meet its service level goal.

 3625_fig5

Workload Designer

The Workload Designer portlet provides an easy-to-use interface that steps the DBA through the normal workflow of defining system states, workload definitions, session controls, filters, throttles, and exception handling. The DBA has highly granular control over each part of the Teradata Dynamic Workload Manager mixed workload controls and configuration.

EB3625_fig4

Meeting SLAs with Peak Performance

Together, the products that make up Teradata Active System Management provide new and better ways to handle increasingly complex production workloads and to prevent bottlenecks. They allow administrators to set specific service level goals, monitor adherence to those goals, then take any necessary steps to reallocate resources to meet business objectives. Teradata’s portfolio of system management products helps ensure the data warehouse efficiently processes the most critical work and keeps the entire enterprise running at peak performance.

The Teradata Difference

Teradata Corporation is the world’s largest company solely focused on creating enterprise agility through database software, enterprise data warehousing, data warehouse appliances, and analytics. Teradata provides the best database for analytics with the architectural flexibility to address any technology and business need for companies of all sizes. Supported by active technology for unmatched performance and scalability, Teradata’s experienced professionals and analytic solutions empower leaders and innovators to create visibility, cutting through the complexities of business to make smarter, faster decisions. Simply put, Teradata solutions give companies the agility to outperform and outmaneuver for the competitive edge.

Teradata brings a blend of technology and experience unavailable from any other source. We’ve been providing innovative, best-in-class business solutions and technologies for some of the world’s most successful data warehouses for 30 years. Our sole focus is on data warehousing. Organizations around the world rely on the power of Teradata’s award-winning solutions and consultants to get a single, integrated view of their business to enhance decision making, customer relationships, and profitability.

Need More Reasons to Choose Teradata?

Teradata customers have deployed our priority scheduler since the mid-1990s to ensure high throughput and efficient system utilization. Building on that priority scheduler foundation, Teradata Active System Management has been installed and maturing in hundreds of systems. Now, after many major releases, Teradata Active System Management is the most proven and mature dynamic workload manager in the data warehousing industry.

For More Information

To learn more about how the Teradata Active System Management portfolio can help you keep real-time information at your fingertips and build a stronger, more profitable business, contact your Teradata representative.