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.
Pricing for Serverless - https://azure.microsoft.com/en-us/pricing/details/sql-database/single/