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

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: • Azure SQL Capacity Pla...
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: docs.microsoft.com/en-us/azur...
vCore model overview: docs.microsoft.com/en-us/azur...
Service tiers in the DTU-based purchase model: docs.microsoft.com/en-us/azur...
Migrate Azure SQL Database from the DTU-based model to the vCore-based model: docs.microsoft.com/en-us/azur...
Query Performance Insight for Azure SQL Database: docs.microsoft.com/en-us/azur...
Troubleshoot with Intelligent Insights: docs.microsoft.com/en-us/azur...
📌 Let's connect:
Twitter - Silvano Coriani, / scoriani
Twitter - Anna Hoffman, / analyticanna
Twitter - AzureSQL, aka.ms/azuresqltw
🔴 Watch even more Data Exposed episodes: aka.ms/dataexposedyt
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: aka.ms/msazuresqlyt
Microsoft SQL Server: aka.ms/mssqlserveryt
Microsoft Developer: aka.ms/microsoftdeveloperyt
#AzureSQL #AzureSQLDB #AzureSQLDatabase #DataExposed

[@olatokekabir2747]

This brief tutorial is an eye opening for every cloud infrastructure manager

[@richardwaldron1684]

That first graphic really helped me get my head around this topic very quickly and effectively (the rest of the video is still good of course, but this is a great intro to the topic). Thanks for posting.

[@ansonwoody]

this video is the best comparing the videos outside with exact numbers. Very good

[@vinayayinapurapu]

Very nice explanation differences between vcore and DTU

[@mateuszdzierzecki5150]

Well explained, thanks!

[@farhanasiraj3451]

I just loved it precious and clear...

[@arindombhattacharya8861]

I keep forgetting about when to use DTU and when Vcore . Hopefully after this video I will not. Thanks for posting