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
Migrating to SQL: Introduction to SSMA (Ep. 3)
Migrating to SQL: Discover and Assess SQL Server Data Estate Migrating to Azure SQL (Ep.2)
Migrating to SQL: Cloud Migration Strategies and Phases in Migration Journey (Ep. 1)
Understanding the Benefits of Intelligent Query Processing
Storage 101 for Azure SQL and SQL Server Engineers
How to Parameterize Notebooks for Automation in Azure Data Studio
Use Helm Charts from Windows Client Machine to Deploy SQL Server 2019 Containers on…
Get Started with Accessing Azure Data Explorer using Apache Spark for Azure Synapse…
Get Started with the New Database Migration Guides to Migrate Your Databases to Azure
Granular Permissions for Azure SQL Dynamic Data Masking
