Whether migrating an existing application or designing a brand new one, capacity planning process plays a critical role.

Learn how to navigate across Azure SQL Database options like hardware generation, service and compute tiers, and instance sizing principles, trying to find the sweet spot between performance, functionalities, and costs, in the first episode of this three-part series with Silvano Coriani.

Content:

  • 0:00 Introduction
  • 0:58 What is capacity planning
  • 2:04 Azure SQL Database dimensions to consider
  • 3:30 Deployment options
  • 4:50 Purchasing models
  • 6:25 Service tiers
  • 7:55 Compute sizes and resource limits

Learn more about the deployment options for Azure SQL Database. 

More information.

[00:00] – Introduction
[00:41] – Deployment options in Azure SQL Database, including elastic pool, single database and Managed Instance
[03:33] – DTU service tiers (Basic, Standard, Premium)
[07:08] – vCore service tiers (General Purpose, Hyperscale, Business Critical)
[08:08] – General Purpose tier: Provisioned vs Serverless
[09:16] – Compute Generation: Gen4 vs Gen5
[10:01] – Decision points for Provisioned vs Serverless compute tiers
[13:25] – Saving money with Azure Hybrid Use Benefits
[13:58] – Business Critical tier and read scale-out
[15:42] – Hyperscale tier
[21:03] – Summary of deployment options
[22:17] – Finalizing the creation of a new Azure SQL Database
[23:02] – Summary and wrap-up