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 threepart 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:    • Azure SQL Capacity Planning: Overview...  

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/enus/azur...
vCore model overview: https://docs.microsoft.com/enus/azur...
Service tiers in the DTUbased purchase model: https://docs.microsoft.com/enus/azur...
Migrate Azure SQL Database from the DTUbased model to the vCorebased model: https://docs.microsoft.com/enus/azur...
Query Performance Insight for Azure SQL Database: https://docs.microsoft.com/enus/azur...
Troubleshoot with Intelligent Insights: https://docs.microsoft.com/enus/azur...

Let's connect:
Twitter Silvano Coriani,   / scoriani  
Twitter Anna Hoffman,   / analyticanna  
Twitter AzureSQL, https://aka.ms/azuresqltw

Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt

Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt

#AzureSQL #AzureSQLDB #AzureSQLDatabase #DataExposed