Improve Query Performance by Managing Statistics in Azure SQL
Build with an Azure free account. Get USD200 credit for 30 days and 12 months of free services.
Start free todayAzure SQL Capacity Planning: DTU or vCore?
Play Azure SQL Capacity Planning: DTU or vCore?
Description
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.
[00:55] Planning for Azure SQL DB deployment
[01:36] DTU model
[02:12] vCore model
[03:12] Differences between DTU model & vCore model
[03:46] DTU benchmark
[05:21] Translating DTU
[08:23] Demo
[11:00] Benefits of virtual cores
[12:45] vCores resource limits
Additional Resources:
Choose between the vCore and DTU purchasing models
vCore model overview
Service tiers in the DTU-based purchase model
Migrate Azure SQL Database from the DTU-based model to the vCore-based model
Query Performance Insight for Azure SQL Database
Troubleshoot with Intelligent Insights
[00:55] Planning for Azure SQL DB deployment
[01:36] DTU model
[02:12] vCore model
[03:12] Differences between DTU model & vCore model
[03:46] DTU benchmark
[05:21] Translating DTU
[08:23] Demo
[11:00] Benefits of virtual cores
[12:45] vCores resource limits
Additional Resources:
Choose between the vCore and DTU purchasing models
vCore model overview
Service tiers in the DTU-based purchase model
Migrate Azure SQL Database from the DTU-based model to the vCore-based model
Query Performance Insight for Azure SQL Database
Troubleshoot with Intelligent Insights
Download
The Discussion
-
Frederi Super interesting! I like to global approach to start on DTU for a new project and see what's going on after a while. The portal interface made me feel like the DTU model was on its way out and I was forcing myself to make some ill-informed decisions in the vCore model.
Thanks again, for this video, and for the channel which I discovered at the same time :)
More episodes in this series
Learn How to Deploy SQL Server 2019 in Containers in Just Minutes
Related episodes
How to Shut Off Public Connectivity to Azure SQL Database
An Introduction to Microsoft Hybrid SQL Server Solutions
Azure SQL Edge: Industry Use Cases & Customer Success
Learn How to Deploy SQL Server 2019 in Containers in Just Minutes
Improve Query Performance by Managing Statistics in Azure SQL
Azure SQL Capacity Planning: Overview
Learning How to Transition Your SQL Server Skills to Azure SQL
Azure SQL for beginners: Call to Action and Resources (61 of 61)
Opportunities in the Cloud with Azure SQL (60 of 61)
Azure SQL: What Else Should I Know (59 of 61)
