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: 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 Intelligent Insights: https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance?WT.mc_id=dataexposed-c9-niner
📌 Let's connect:
Twitter - Silvano Coriani, http://twitter.com/scoriani
Twitter - Anna Hoffman, https://twitter.com/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
Видео Azure SQL Capacity Planning: DTU or vCore? | Data Exposed канала Microsoft Developer
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 Intelligent Insights: https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance?WT.mc_id=dataexposed-c9-niner
📌 Let's connect:
Twitter - Silvano Coriani, http://twitter.com/scoriani
Twitter - Anna Hoffman, https://twitter.com/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
Видео Azure SQL Capacity Planning: DTU or vCore? | Data Exposed канала Microsoft Developer
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Secure Azure SQL and Deliver Consistent Performance | Azure SQL Bootcamp (Session 2)](https://i.ytimg.com/vi/WXNRU82x1vs/default.jpg)
![Benchmarking SQL Server and Azure SQL with WorkloadTools | Data Exposed: MVP Edition](https://i.ytimg.com/vi/LgVHK9IBXSc/default.jpg)
![OSS Framework Support in Azure Machine Learning Service](https://i.ytimg.com/vi/zH1UojWq0oU/default.jpg)
![Choosing The Right Azure SQL Service for You](https://i.ytimg.com/vi/MVN9E3D2RO8/default.jpg)
![Inside Azure datacenter architecture with Mark Russinovich - BRK3060](https://i.ytimg.com/vi/S2zguwKvlQk/default.jpg)
![Deploying .NET Apps to Azure](https://i.ytimg.com/vi/6VK370-Yk3A/default.jpg)
![Improve Query Performance by Managing Statistics in Azure SQL | Data Exposed: MVP Edition](https://i.ytimg.com/vi/2nSx9wuJKt4/default.jpg)
![Azure Databricks Tutorial | Data transformations at scale](https://i.ytimg.com/vi/M7t1T1Q5MNc/default.jpg)
![Azure Data Factory Parametrization Tutorial](https://i.ytimg.com/vi/pISBgwrdxPM/default.jpg)
![Create Solutions with Azure SQL and Get Your Questions Answered | Azure SQL Bootcamp (Session 4)](https://i.ytimg.com/vi/z3j1qq9T5Rs/default.jpg)
![Azure Monitor - Application Insights - Intro to Availability Monitoring](https://i.ytimg.com/vi/FRlWiAzjHC8/default.jpg)
![From SQL to Azure Cosmos DB - Jimmy Bogard](https://i.ytimg.com/vi/II9FuVkMBXQ/default.jpg)
![AI Show | Scikit-Learn with Andreas Müller](https://i.ytimg.com/vi/ZEq0ivR_pzg/default.jpg)
![Azure SQL Capacity Planning: Overview | Data Exposed](https://i.ytimg.com/vi/BbcVl9ZKtf8/default.jpg)
![Microsoft Azure Overview](https://i.ytimg.com/vi/_ElhzkYYQpM/default.jpg)
![Top 3 Pitfalls of Managing Your Azure SQL DB Costs](https://i.ytimg.com/vi/2K3ABlVyonw/default.jpg)
![Application Insights The Tool You Never Knew You Needed](https://i.ytimg.com/vi/SMGokUCi9oo/default.jpg)
![Learn How to Deploy SQL Server 2019 in Containers in Just Minutes | Data Exposed: MVP Edition](https://i.ytimg.com/vi/qUqXdEmLtm8/default.jpg)
![New features for Azure Arc Enabled Servers using Extensions ☁🖥](https://i.ytimg.com/vi/ZaKk4ucVCt4/default.jpg)