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:

Basic Standard Premium Premium RS
SLA 99.99% 99.99% 99.99% 99.99%
Workloads Dev, Demos, POC, Limited Production Dev & Production Dev & Production Dev & Production
DB Backup retention 7 days 7 days 7 days 7 days
CPU Priority Low Low, Medium, High Medium & High Medium & High
IOPS 2.5 per DTU 2.5 per DTU 48 IOPS per DTU
IOPS Latency Normal 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) No S3 & Above Yes Yes
Max DB Size 5 GB 1 TB 4 TB 4 TB
Max DTUs 5 3000 4000 4000
Max eDTUs per DB 2 GB 1 TB 1 TB
Max eDTU per Pool 1600 3000 4000
Max DBs per Pool 500 500 100

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.