Teradata Dynamic Resource Optimization – Both On-Premises and in the Cloud

Teradata’s dynamic resource optimization didn’t spring up overnight. It evolved over time to match the growing sophistication of enterprise users and to respond to their increasingly complex mix of work. For example, the original Teradata Advanced SQL Engine (formerly known as Teradata Database) came with four different priority levels. Everything that was executed in the database ran at one of those four levels. Before Teradata users had even thought about needing workload management, the database itself used those contrasting priorities to control the level of resources being offered to different internal tasks and to influence the speed at which they were completed. Read more about prioritization in the Advanced SQL Engine here.

Today, there are hundreds of different priority levels a user can draw upon, and special concurrency rules can easily be put in place to even-out surges in demand. Some of they key features of today’s workload management include:
 

• Prioritization, which allocates resources based on specific business requirements
• Exception handling that dynamically reduces the priority of poorly-behaving requests
• Concurrency control rules; to give users control over what runs, when it runs, and how much of it runs
• Limits on the level of CPU and I/O that a workload can consume
• Ability to protect critical online application performance and load job SLAs while all other work is active
• Automatic rule changes to accommodate different needs at different times of the day or month
• Detection and reaction to unusual system events or extreme resource usage 

Teradata dynamic resource optimization is extensible and simple to modify. Users can be assured that whatever growth and change comes their way, they will be able to adapt the Teradata workload management rules easily.

Teradata Vantage on Azure

To be clear, the same array of dynamic resource optimization tools that are available with Teradata Vantage on-premises are also available with Teradata Vantage on Azure. This implies that customers do not have to settle for “basic” cloud data warehouses that do not have advanced workload management capabilities and hence require customers to create separate data marts (read: separate data silos) in order to handle enterprise scale, concurrent workloads.

With Teradata Vantage on Azure, customers have access to the same industry-leading dynamic resource optimization tools that they have come to love with the added agility that Azure brings to the table as a hyper-scale, hybrid cloud vendor.

A customer example

A leading consumer electronics retailer needed to extend the capabilities of its on-premises system, as well as their increased focus on Data Governance, Risk and Compliance (DGRC), coincided with their desire to move to the cloud for better agility. They viewed Vantage on Azure as the best solution to protect their existing data platform, ensure the continuity of business operations, and protect the large amount of customer data on-premises.
 

“Workload management and best database out there! [Other solutions] could not handle the workload for queries that Teradata does; it could not even come close.”
 
For more information on Teradata Dynamic Resource Optimization today, view this short video here. 

For additional use cases and key features of Vantage on Azure, please visit https://www.teradata.com/Cloud/Azure.