Azure SQL Database Pricing examples

To determine if a cloud solution is cost effective, it helps to know the price of the components of the solution from an Azure billing point of view.

Some Azure SQL Database Pricing examples from the official documentation -

Pricing example for a single database with extra storage provisioned
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.0851/GB/month during preview, and so the extra storage price is 774 GB * $0.0851/GB/month = $65.80/month . 

Therefore, the total price for the S3 database is $148/month for DTUs + $65.80/month for extra storage = $213.38/month.

Pricing example for an elastic pool with extra storage provisioned
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 1 TB – 250 GB = 774 GB. 

The unit price for extra storage in the Premium tier is approximately $0.1701/GB/month during preview, and so the extra storage price is 774 GB * $0.1701/GB/month = $131.58/month . 

Therefore, the total price for the pool is $686.25/month for pool eDTUs + $131.58/month for extra storage = $817.83/month.

Comments