Whitepaper : Azure SQL Hyperscale

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.

This whitepaper presents the design goals, the performance comparison, the SQL Server features used, the architectural overview, and the configuration of Azure SQL Hyperscale.

Author: Richard Giles

Richard Giles is an accomplished software and database architect. He has been developing commercial software for over 30 years and has played key 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.

Register to read the full whitepaper.

See Also:

Topics : Cloud Databases,Database Diagnostics,Database Monitoring,

Products : SQL Diagnostic Manager for SQL Server,

Register for Free Whitepaper

Note: By filling and submitting this form you understand and agree that the use of IDERA’s website is subject to the General Website Terms of Use. Additional details regarding IDERA’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.