August 8, 2022
Do you require higher performance and availability, fastback and restore, or fast storage and compute scalability? Are you moving to the cloud to modernize your applications, or are you already using other service tiers in Azure SQL Database? If so, the Azure SQL Database based on the SQL Server Database Engine architecture may be the right fit for you.
A Hyperscale database is a database in SQL Database that is backed by the Hyperscale scale-out storage technology. A Hyperscale database supports up to 100 TB of data and provides high throughput, performance, and rapid scaling to adapt to the workload requirements. Connectivity, query processing, database engine features, etc., work like any other database in Azure SQL Database.
There are three architectural models used in Azure SQL Database, General Purpose/Standard, Hyperscale, and Business Critical/Premium. The details for each are listed below.
All three tiers offer a choice of geo-redundant, zone-redundant, or locally redundant backup storage, with a 1 to 35-day retention (the default is seven days).
Hyperscale removes many of the practical limits traditionally seen in cloud databases. Where most other databases are limited by the resources available in a single node, databases in the Hyperscale have no such limitations. With its flexible storage architecture, storage grows as needed. Hyperscale databases aren’t created with defined maximum sizes. A Hyperscale database grows as required – and you’re billed only for the capacity you use. For read-intensive workloads, Hyperscale provides rapid scale-out by provisioning additional replicas as needed for offloading read workloads.
The time required to create database backups or to scale up or down is no longer tied to the volume of data in the database. Hyperscale databases can be backed up virtually instantaneously. You can also scale a database in the tens of terabytes up or down in minutes. This capability frees you from concerns about being boxed in by your initial configuration choices.
Although hyper-scale offers many benefits, it may not be the best fit for your organization. Hyperscale is particularly advantageous to you in the following scenarios: