Azure SQL Capacity Planning: DTU or vCore? | Data Exposed

From the creator

Capacity planning process plays a critical role in migrating to an existing application or designing a brand new one. In the second part of this three-part series with Silvano Coriani, learn about the differences between DTU and vCore when planning for your Azure SQL Database. For an overview of Azure SQL Capacity planning, watch part one: https://youtu.be/BbcVl9ZKtf8?WT.mc_id=dataexposed-c9-niner 0:00 Introduction 0:55 Planning for Azure SQL DB deployment 1:36 DTU model 2:12 vCore model 3:12 Differences between DTU model & vCore model 3:46 DTU benchmark 5:21 Translating DTU 8:23 Demo 11:00 Benefits of virtual cores 12:45 vCores resource limits ✔️Resources: 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-insight-use?WT.mc_id=dataexposed-c9-niner Troubleshoot with

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