SQL Server 2019 Improves Scalar UDF Performance
Build with an Azure free account. Get USD200 credit for 30 days and 12 months of free services.
Start free todayAzure SQL Capacity Planning: Overview
Play Azure SQL Capacity Planning: Overview
Description
Whether migrating an existing application or designing a brand new one, capacity planning process plays a critical role. Learn how to navigate across Azure SQL Database options like hardware generation, service and compute tiers and instance sizing principles, trying to find the sweet spot between performance, functionalities and costs, in the first episode of this three-part series.
[00:58] What is capacity planning
[02:04] Azure SQL Database dimensions to consider
[03:30] Deployment options
[04:50]Purchasing models
[06:25] Service tiers
[07:55] Compute sizes and 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
rss
The Discussion
More episodes in this series
Improve Query Performance by Managing Statistics in Azure SQL
Related episodes
Azure SQL Connectivity Performance Tips & Tricks
Simplify Authentication with Managed Identities for Azure Resources
How to Troubleshoot Elastic Jobs in Azure SQL Database
Running & Monitoring Elastic Jobs in Azure SQL Database Using PowerShell and T-SQL
How to Create Elastic Jobs in Azure SQL Database Using T-SQL
How to Create Elastic Jobs in Azure SQL Database Using PowerShell
The A to S of Azure Data Studio
Understanding High-Performant, Hybrid Data Integration Using Azure Data Factory
Azure SQL from the Edge to the Cloud
Use Azure Pipelines for Azure SQL Deployments
