Azure SQL Standard vs Premium

Azure SQL Standard vs Premium Specification Comparison & Differences

In this article, we will be comparing Azure SQL Standard vs Premium service tiers. We have also included the basic tier since it is widely used for development purposes. The DTU based cost models are differentiated by a different range of computing sizes, along with a fixed amount of storage, fixed backup retention periods, and a fixed price.

All of these service tiers are billed on an hourly basis. It encourages customers to utilize the elasticity options available for maximum benefits fully. So, let’s get started with our comparison.

Azure SQL Standard vs Premium: Comparison

We begin with the comparison table of Azure SQL Standard vs Premium, along with the basic option. As you can see from the table below, the premium tier is using SSDs for more IOPS, and better Read/Write performance. Refer below:

BasicStandardPremiumPremium RS
SLA99.99%99.99%99.99%99.99%
WorkloadsDev, Demos, POC, Limited ProductionDev & ProductionDev & ProductionDev & Production
DB Backup retention7 days7 days7 days7 days
CPU PriorityLowLow, Medium, HighMedium & HighMedium & High
IOPS2.5 per DTU2.5 per DTU48 IOPS per DTU
IOPS LatencyNormal Disks

5 ms (read), & 10 ms (write)

Normal Disks

5-10 milliseconds disk latency @ 7000 IOPS for Logs

NVMe based SSDs

1-2 milliseconds disk latency @ 200,000 IOPS for Data

1-2 milliseconds disk latency @ 200,000 IOPS for Logs

NVMe based SSDs

1-2 milliseconds disk latency @ 200,000 IOPS for Data

1-2 milliseconds disk latency @ 200,000 IOPS for Logs

CCI (Index)NoS3 & AboveYesYes
Max DB Size5 GB1 TB4 TB4 TB
Max DTUs5300040004000
Max eDTUs per DB2 GB1 TB1 TB
Max eDTU per Pool160030004000
Max DBs per Pool500500100

Do note that we excluded “Managed Instances” out of the scope of this article since it does not offer a DTU based purchasing model. Microsoft uses a calibrated benchmark which runs random tests against a standard schema to determine DTU workloads under real-world database stress tests.

You will also take into consideration the fact that each application is unique and will behave differently. In your tests, you might need a higher service tier or vice versa. This is because, in reality, databases comprises of different sizes and varied complexity.

When it encounters different mixes of workloads, it is expected to respond in different ways. For example, an IO-intensive app may hit the upper limits of the IO thresholds sooner, or a CPU-bound application with complex database computations may beat CPU upper limits faster.

Conclusion

Choosing the right DTU numbers might be difficult to estimate in the first go. We recommend testing your development system with various workloads to see if your application is more CPU, Memory or IO intensive. As you can see from the above table, Premium DBs can bring in more IOPS at a higher price.

In case if you want more flexibility in choosing individual workloads, we recommend going with the vCore licensing model.

We hope our article helped choose the right service tier for your Azure SQL Database. Suggestions and questions are welcome in the comment section below. Thanks for visiting.

Official Information:

Disclaimer: The Questions and Answers provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose.