This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.
We are excited to announce the public preview of 128 vCore provisioned compute size for Azure SQL Standard-series (Gen5) General Purpose and Business Critical databases and elastic pools. Enabling customer demands for increased scalability, Standard-series (Gen5) provisioned databases and elastic pools can now scale to 128 vCores and 625 GB of memory, beyond the previous max of 80 vCores and 415GB of memory.
What are the benefits of 128 vCore compute size?
- 128 vCore compute sizes run on latest Intel Xeon Platinum 8307C (Icelake) and AMD EPYC™ 7763v (Milan) chipsets. More cores improve workload throughput, and newer chipsets improve single core performance.
- For Business Critical databases and elastic pools, max data IOPS is the highest available in any Azure SQL compute size, at 327,680 and 409,600 IOPS respectively.
- Max concurrent workers for General Purpose and Business Critical databases and pools increases to 12,800 and 13,440 respectively.
Gen5 Hardware generation is being renamed to ‘Standard-series’
Effective today, we’re renaming the Gen 5 hardware generation to “standard-series (Gen 5)”.
Please note that this change applies only to Azure Portal and the supporting documentation. If you are using the REST API or an ARM template to create your standard-series (Gen 5) SQL database, your existing scripts will continue to work.
Using the 128 vCore compute size is simple
Customers can create a new database and elastic pool, or scale up an existing Azure SQL database or elastic pool to take advantage of 128 vCore compute size.
Some limitations apply during preview
- 128 vCore compute size public preview is only supported in following regions at the moment, but we will be expanding regional availability in the coming months.
- Australia East,
- Canada Central,
- East US,
- Japan East,
- North Europe,
- West Europe,
- South Central US,
- West US1,
- West US2,
- UK South
- Zone redundancy is not available for 128 vCore compute sizes at public preview launch, but will be supported in early 2023.
- SQL Maintenance Window is not available for 128 vCore compute sizes at public preview launch but will be supported in early 2023.