Azure SQL Server DBA

Scaling, Elastic Pools & Hyperscale

Question

A database is idle overnight but has variable daytime demand. Which compute model fits?

Answer

Choose serverless Azure SQL Database. Set suitable minimum and maximum vCores, assess auto-pause suitability, and test resume latency with the application. Keep provisioned compute when the workload requires continuously ready capacity.

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

More Azure SQL Server DBA topic samples