Azure SQL Database Serverless -Disable Auto Pause Cost?

October 26, 2020

In this blog post, I discussed some facts about Azure SQL Database Serverless. If someone wants to avoid those limitations and disable ‘Auto-pause,’ how costly is it?

Suppose a serverless database is not paused and configured with 4 max vCores and 0.5 min vCores corresponding to 2.1 GB min memory. Then the minimum compute bill is based on max (0.5 vCores, 2.1 GB * 1 vCore / 3 GB) = 0.7 vCores.

https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview#billing

.7*3600*24=60480 vCore Seconds, assuming server was at minimum vCore for 24 hours.

If we assume that the ‘auto-pause’ database was idle at 50% of the time, minimum vCore (.5) was assigned to server computing for 12 hours every 24 hours.

At the time of writing this blog post, the compute unit price is $0.000145/vCore/second.

Daily cost of turning off auto-pause (30240 vCore Seconds * $.000145/vCore/Second) is $4.38. $30.66/weekly and $131.4/Monthly.

I hope this helps you make choices if you should turn on/off ‘‘Auto-pause delay’ in the Azure SQL database serverless.

Ref: Azure SQL Database serverless

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.