Automated Database Workload Analysis: Insights You Need For Replatforming

Cloud News Roundup – Acquisitions Indicate Bright Future for the Cloud


Three Reasons Enterprises are Thankful for the Cloud


The data warehouse and the value that it brings to the enterprise is what enables your company to compete, differentiate, and succeed. To stay competitive and gain an edge, you’ve made the decision to move your data warehouse to the cloud so that the company can benefit from the latest business analytics innovation and agility available in cloud data warehouses.

Business requirements and increasing data complexity have ensured that your data warehouses architecture is complicated. DBAs, engineers, architects, and analysts have come and gone. Code has been written. Bugs have been fixed. And, most likely, not much clean-up has happened, because, let’s be honest, how often does data warehouse spring cleaning get prioritized? More often, the familiar mantra of “if it ain’t broke, don’t fix it” is followed.

Given the tangled nature of enterprise data warehouses, the replatforming journey is far from straightforward. Considerations for a replatforming project include ensuring predictable costs for the new data warehouse, leveraging storage and compute insights to optimize your workload and right-size it for the cloud, providing uninterrupted service for your users, and more. It requires planning, knowledge, and insights to ensure a successful execution.

You will need to decide which of the following replatforming strategies is most suitable for your enterprise:

  • Replatform the entire data warehouse
  • Deploy a staged approach
  • Split off individual workloads to replatform

You will also need a complete and comprehensive analysis of your data warehouse that answers the following questions:

  • What is the difficulty and complexity of the workloads to be replatformed?
  • What is the size of the current data warehouse and what capacity is needed?
  • What specific risks and obstacles stand in the way of successfully replatforming?

Get Fast and Full Visibility into the Complexity of your Data Warehouse

With Datometry qInsight software, you can quickly and easily surface the information that allows you to choose the optimal plan for your cloud data warehouse. The comprehensive insights on storage and compute will help optimize your workload and right-size it for the cloud. It takes just two simple steps to get your report: extract log data and upload the extract to the qInsight portal.

Here is a sample report from a customer’s on-premise Teradata warehouse.


qInsight Product


This functional and operational analysis is well beyond anything database logs or standard tools can provide, and includes:

  • Datometry qScore™ computed for each workload based on usage and frequency of query features—including proprietary SQL constructs—and other parameters that affect rewriting of applications
  • Suitability of the workloads for the selected cloud data warehouse
  • Count of unique queries determined by query structure, so you can tell how many statements need to be rewritten and get a more realistic picture of the scale of the project
  • Statement analysis by application combines and contrasts daily query volume with actual workload complexity
  • Data usage statistics show immediate capacity savings based on the time of last access
  • High-resolution analysis of workload patterns with controls for interactive exploration lets customers determine the true TCO of the new target platform.
  • Isolate and prioritize workloads when pursuing a multi-cluster strategy

The qInsight reports will help you map out the most efficient and least risky path to the cloud in the shortest time possible.

To learn more about these features and what qInsight offers, check out our product page for more details and get started with qInsight today.

7 things every IT leader should know before moving analytics to the cloud
Download PDF
Author avatar

About Michele Gage

Product Manager

Michele is a Bay Area native who has served as a product manager for notable business apps and platforms for the last seven years. She comes from a technical family and has always had a penchant for tech - especially since her mom taught her how to write SQL queries instead of how to cook. Specializing in database technology, Michele feels right at home among the database experts at Datometry.

Continue Reading