Azure SQL Capacity Planning: Overview | Data Exposed

From the creator

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. 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 ✔️Resources: Azure SQL Capacity Planning: DTU or vCore?: https://youtu.be/1AKDj0_wOFs?WT.mc_id=dataexposed-c9-niner Choose between the vCore and DTU purchasing models: https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models?WT.mc_id=dataexposed-c9-niner vCore model overview: https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-vcore?tabs=azure-portal?WT.mc_id=dataexposed-c9-niner Service tiers in the DTU-based purchase model: https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu?WT.mc_id=dataexposed-c9-niner Migrate Azure SQL Database from the DTU-based model to the vCore-based model: https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-dtu-to-vcore?WT.mc_id=dataexposed-c9-niner Query Performance Insight for Azure SQL Database: https://docs.microsoft.com/en-us/azure/azure-sql/database/query-performance

Published 2020-08-13 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.