{"id":30036,"date":"2020-03-26T09:00:09","date_gmt":"2020-03-26T16:00:09","guid":{"rendered":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/?p=30036"},"modified":"2024-01-22T22:51:25","modified_gmt":"2024-01-23T06:51:25","slug":"use-hyperscale-for-your-most-demanding-cloud-born-workloads","status":"publish","type":"post","link":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/","title":{"rendered":"Use hyperscale for your most demanding cloud-born workloads"},"content":{"rendered":"

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<\/a> 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<\/a>.<\/em><\/p>\n

Each single database in Azure SQL Database service<\/a> 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\u2019re 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.<\/p>\n

The benefits of hyperscale<\/h2>\n

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\u2019t have those limits in the hyperscale service tier. Hyperscale databases aren\u2019t created with a defined maximum size. A flexible storage architecture allows a hyperscale database to grow as needed. And you\u2019re only billed for the capacity you use.<\/p>\n

The hyperscale service tier also won’t box you into your initial configuration. Hyperscale databases can be backed up almost instantaneously\u2014regardless of the volume of data in the database. You can also scale a database in the tens of terabytes in minutes.<\/p>\n

Do you need to go hyperscale?<\/h2>\n

The hyperscale service tier supports a broad range of SQL Server workloads, from pure online transactional processing (OLTP) to pure analytics. However, it\u2019s 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:<\/p>\n