What is Azure SQL Hyperscale high-performance database-as-a-service?

by Oct 3, 2019

Azure SQL Hyperscale is a new database as a service (DBaaS) offering from Microsoft. Microsoft built Azure SQL Hyperscale on the experiences learned by Microsoft Azure SQL Database. Azure SQL Hyperscale strives for improvements in security and availability plus lower and more flexible cost, and higher performance.

Azure SQL Hyperscale is based on the idea of separating compute and storage that other vendors such as Amazon and Oracle have modeled products on. However, Azure SQL Hyperscale architecture also separates durability and availability. That separation helps meet a customer need for the balancing of cost, performance, and availability.

Microsoft has released a single database version of Azure SQL Hyperscale. However, Microsoft is working on future improvements for bulk operations, multiple-master variants, better support for the hybrid transaction/analytical processing (HTAP) as can be found in MariaDB, and making use of the Log Service for other services such as audit and security.

Azure SQL Hyperscale is designed to be able to migrate from Azure SQL Databases. And Azure SQL Hyperscale is intended to have no impact on current applications and tools designed for Azure SQL Databases. The lack of adverse effects is good news for third-party vendors, including IDERA.

Read the 9-page whitepaper "Azure SQL Hyperscale High-performance DBaaS" by Richard Giles to learn about Azure SQL Hyperscale and its design goals, performance compared to Azure SQL Database, features shared with SQL Server, architecture, and configuration.

Click here to read the whitepaper.

The author, Richard Giles, is an accomplished Software and Database Architect. He has been developing commercial software for over 30 years and has played critical roles in building successful products, including Microsoft Operations Manager and Idera SQL Server product line. Richard is currently providing Technical Product Consulting services as a Consultant. He has been involved with Microsoft Partner programs for over 20 years and has actively tested Microsoft products as part of the Insider program. Richard has a strong analytical ability, is thorough when researching emerging technology, and takes great pride in producing innovative solutions. Always the consummate learner, he has been actively learning about new technologies for most of his career and has focused on Database Platforms, Data Science, Analytics, and Cloud Computing.

 

To learn more about IDERA's solution for managing databases in the hybrid cloud, view the cloud solutions webpage.