Sometimes resource demands increase beyond your expectations. Azure SQL Database service continues to meet your needs regardless of your speed of growth. The hyperscale service tier for a single database enables you to scale to 100 TB with fast backup and restore capabilities. Learn about other options for running Microsoft SQL Server in Azure in the e-book Future-Proof Your Data Infrastructure with Azure: A Business Case for Database Administrators.
Each single database in Azure SQL Database service is guaranteed its own dedicated compute, memory, and storage resources that you can scale dynamically. If you need to scale out the storage and compute resources substantially beyond the limits for the general purpose and business critical service tiers, you’re in luck. The hyperscale service tier provides highly scalable storage and compute performance that leverages the Azure architecture to meet the largest needs of an Azure SQL Database.
The benefits of hyperscale
With the hyperscale service tier, Microsoft removed many of the limits seen in other cloud databases. For example, most other databases are limited by the resources available in a single node. You don’t have those limits in the hyperscale service tier. Hyperscale databases aren’t created with a defined maximum size. A flexible storage architecture allows a hyperscale database to grow as needed. And you’re only billed for the capacity you use.
The hyperscale service tier also won’t box you into your initial configuration. Hyperscale databases can be backed up almost instantaneouslyregardless of the volume of data in the database. You can also scale a database in the tens of terabytes in minutes.
Do you need to go hyperscale?
The hyperscale service tier supports a broad range of SQL Server workloads, from pure online transactional processing (OLTP) to pure analytics. However, it’s optimized for OLTP and hybrid transaction and analytical processing (HTAP) workloads. That said, hyperscale provides flexibility and high performance, two features that can benefit most business workloads. However, hyperscale will be particularly advantageous to you in the following scenarios:
- If you have a large on-premises database and want to modernize applications by moving them to the cloud.
- If you’re running databases in Azure but are limited by the database size restrictions of the other service tiers.
- If you have smaller databases that require fast compute scaling, high performance, instant backup, and fast database restore.
The hyperscale architectural model provides nearly instantaneous database backups with no impact on compute resources, the database restores in minutes rather than hours or days, and there is higher overall performance, and rapid scale-out and scale-up. Now there’s no need to worry about how much or how fast your database will grow. The hyperscale service tier in Azure SQL Database has you covered.
To learn more about moving SQL Server to the cloud, download Future-Proof Your Data Infrastructure with Azure: A Business Case for Database Administrators.
The post Use hyperscale for your most demanding cloud-born workloads appeared first on SQL Server Blog.