Edit

Azure SQL Database serverless compute tier FAQ

Applies to: Azure SQL Database

This article answers frequently asked questions about the serverless compute tier in Azure SQL Database.

General

Does Azure SQL Database Hyperscale support the serverless compute tier?

Yes, the serverless compute tier is supported in the Hyperscale service tier. However, Hyperscale doesn't currently support auto-pause and auto-resume.

Which service tiers support the serverless compute tier?

The serverless compute tier is available in the Hyperscale and General Purpose service tiers using the vCore purchasing model. It's not available in the DTU purchasing model. Only Standard-series (Gen5) hardware is supported.

Which application or load scenarios are best for the Azure SQL Database serverless compute tier?

Serverless is price-performance optimized for single databases with intermittent, unpredictable usage patterns that can afford some delay in compute warm-up after idle usage periods. In contrast, the provisioned compute tier is price-performance optimized for single databases or multiple databases in elastic pools with higher average usage that can't afford any delay in compute warm-up. For more information and scenarios well suited for serverless, see Serverless compute tier for Azure SQL Database.

Auto-pause and auto-resume

What happens when my serverless database is paused and a connection is attempted?

When a serverless database is paused, the first connection attempt resumes the database. Applications might receive an error stating that the database is unavailable with error code 40613. Once the database is resumed, retry the connection. Database clients that follow connection retry logic recommendations shouldn't need to be modified. For more information, see Auto-pause and auto-resume in serverless.

Why doesn't my serverless database auto-pause after the delay period?

Several features prevent auto-pausing, including active geo-replication, failover groups, long-term backup retention (LTR), DNS aliases, and elastic jobs (when the database is used as a job database). Additionally, open application or user sessions prevent auto-pausing. To troubleshoot, check for open sessions by querying sys.dm_exec_sessions. For more information, see Auto-pause troubleshooting.

Billing

Can I use Azure Hybrid Benefit or reserved capacity with the serverless compute tier?

No. Azure Hybrid Benefit (AHB) and Azure Reservations discounts don't apply to the serverless compute tier. For more information, see Serverless compute tier billing.

How is the minimum compute bill calculated for a serverless database?

When a serverless database is paused, you aren't billed for compute. If the database isn't paused, the minimum compute bill scales with the maximum setting. For more information and examples, see Minimum compute bill.