Azure SQL Server DBA

Deployment Options, Service Tiers & Cost Management

Question

An infrequently used single database has unpredictable daytime demand and accepts a warm-up delay; which tier fits?

Answer

Choose serverless Azure SQL Database. Set minimum and maximum vCores from observed demand, choose an auto-pause delay compatible with application behavior, and monitor billed compute plus storage. Disable auto-pause if resume latency becomes unacceptable.

This is 1 of 19 free samples for Azure SQL Server DBA.

More Azure SQL Server DBA topic samples