Friday, December 06, 2019

Data Platform Tips 20 - Azure SQL Database Serverless

Optimising computer resources especially database resources on Azure is challenging especially making it cost effective. Microsoft released "Azure SQL Database Serverless" to solve this problem.

In SQL Database serverless, compute is only billed based on the amount of CPU and memory used per second. When the database is paused only storage is billed.

  • Compute unit price for Serverless database is higher than provisioned compute database so understanding the database workloads memory and CPU is important before making decision to use Serverless.
  • The latency to pause and resume a serverless database is usually around one minute or less during which time the database is offline. 
  • While a serverless database is online, memory is gradually reclaimed if CPU or memory usage is low enough for long enough.

No comments:

Post a Comment