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.