New performance levels and storage add-ons in Azure SQL Database

Publié le 30 août, 2017

Principal Program Manager

We are pleased to announce the public preview of new performance levels and storage add-ons in Azure SQL Database. These new choices enable further price optimization opportunities for CPU intensive and storage bound workloads.

Higher performance levels for Standard databases

Previously, the highest performance level for a single database in the Standard tier was limited to 100 DTUs and now increases by 30x to 3000 DTUs with a range of new choices in between. This update follows a similar update which increased the database eDTU limits for Standard elastic pools. The new S4 – S12 performance levels provide price savings opportunities for CPU intensive workloads that do not demand the kind of high IO performance provided by the Premium tier. For IO intensive workloads, the Premium tier continues to provide lower latency per IO and an order of magnitude more IOPS per DTU than in the Standard tier.

Storage add-ons for single databases and elastic pools

Previously, the storage size limit was a fixed amount based on the service tier and performance level. Customers can now purchase extra storage above this included amount for single databases and elastic pools in the Standard and Premium tiers. The decoupling of storage from compute reduces costs by allowing more storage without having to increase DTUs or eDTUs.

Storage provisioned above the included amount is charged extra and billed on an hourly basis. The total price for a single database (or an elastic pool) is the price based on DTUs (or eDTUs) plus the price for any extra storage provisioned. Storage for a single database or elastic pool can be provisioned in increments of 250 GB up to 1 TB, and then in increments of 256 GB beyond 1 TB.

Extra storage unit price

image

Example

Suppose an S3 database has provisioned 1 TB. The amount of storage included for S3 is 250 GB, and so the extra storage amount is 1 TB – 250 GB = 774 GB. The unit price for extra storage in the Standard tier is approximately $0.085/GB/month during preview, and so the extra storage price is 774 GB * $0.085/GB/month = $65.79/month. Therefore, the total price for this database is $150/month for DTUs + $65.79/month for extra storage = $215.79/month.

New performance levels and storage limits

Single database

image

Elastic pool

image

Learn more

To learn more about the new performance levels and storage add-on choices available, please visit the Azure SQL Database resource limits webpage. And for more pricing information, please visit the Azure SQL Database pricing webpage.