Azure SQL Pricing pattern

Azure pricing can be quite complex to understand at times. This blog focuses on specifically Azure SQL Pricing models.

Azure SQL Pricing Models

vCore Purchase Model - The vCore purchasing model offers trade off for performance and storage. has two performance tiers, which are General Purpose (GP) and Business Critical (BC). 

DTU Purchase Model - This model offers SQL Azure in three tiers namely Basic Tier, Standard Tier, Premium Tier.

DTU Pricing Model Standard Tier

       Premium service tier - Following table illustrates included storage and max storage options.

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 1024 GB – 250 GB = 774 GB. The unit price for extra storage in the Standard tier is approximately ₹16.86/GB/month, and so the extra storage price is 774 GB * ₹16.86/GB/month = ₹13,045.42/month. Therefore, the total price for the S3 database is ₹10,116.88/month for DTUs + ₹13,045.42/month for extra storage = ₹23,162.30/month.

Suppose a 125 eDTU Premium pool has provisioned 1 TB. The amount of storage included for a 125 eDTU Premium pool is 250 GB, and so the extra storage amount is 1024 GB – 250 GB = 774 GB. The unit price for extra storage in the Premium tier is approximately ₹33.71/GB/month, and so the extra storage price is 774 GB * ₹33.71/GB/month = ₹26,090.84/month. Therefore, the total price for the pool is ₹51,743.39/month for pool eDTUs + ₹26,090.84/month for extra storage = ₹77,834.22/month.

One should always know about their workloads expected during given period of time and choose accordingly which type of purchase option will be good for their application.