%3CLINGO-SUB%20id%3D%22lingo-sub-1754908%22%20slang%3D%22en-US%22%3EAzure%20SQL%20Capacity%20Planning%3A%20Scenarios%20%7C%20Data%20Exposed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1754908%22%20slang%3D%22en-US%22%3E%3CP%3ECapacity%20planning%20plays%20a%20critical%20role%20in%20migrating%20an%20existing%20application%20or%20designing%20a%20new%20one.%20In%20the%20final%20part%20of%20this%20three-part%20series%20with%20Silvano%20Coriani%2C%20we'll%20review%20various%20Azure%20SQL%20capacity%20planning%20scenarios%2C%20as%20well%20as%20review%20best%20practices%20and%20recommendations%20on%20what%20to%20use%20when.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20an%20overview%20of%20Azure%20SQL%20Capacity%20planning%2C%20watch%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%2FAzure-SQL-Capacity-Planning-Overview%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Epart%20one.%3C%2FA%3E%3C%2FP%3E%0A%3CP%3ETo%20learn%20about%20the%20differences%20between%20DTU%20and%20vCore%2C%20watch%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-sql-database%2Fazure-sql-capacity-planning-dtu-or-vcore-data-exposed%2Fba-p%2F1594528%22%20target%3D%22_blank%22%3Epart%20two%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2Fq8yPvGVfZ2k%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSPAN%20style%3D%22font-size%3A%2018.0pt%3B%22%3EWatch%20on%20Data%20Exposed%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3EResources%3A%3C%2FEM%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fpurchasing-models%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChoose%20between%20the%20vCore%20and%20DTU%20purchasing%20models%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fservice-tiers-vcore%3Ftabs%3Dazure-portal%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EvCore%20model%20overview%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fservice-tiers-dtu%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EService%20tiers%20in%20the%20DTU-based%20purchase%20model%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fmigrate-dtu-to-vcore%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMigrate%20Azure%20SQL%20Database%20from%20the%20DTU-based%20model%20to%20the%20vCore-based%20model%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fquery-performance-insight-use%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EQuery%20Performance%20Insight%20for%20Azure%20SQL%20Database%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fintelligent-insights-troubleshoot-performance%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ETroubleshoot%20with%20Intelligent%20Insights%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EView%2Fshare%20our%20latest%20episodes%20on%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChannel%209%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLlrxD0HtieHieV7Jls72yFPSKyGqycbZR%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EYouTube%3C%2FA%3E!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1754908%22%20slang%3D%22en-US%22%3E%3CP%3E%3CBR%20%2F%3ESee%20Azure%20SQL%20capacity%20planning%20in%20action%20with%20various%20scenarios.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201130iE9AAF33173512AF8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22MSDataExposed.jpg%22%20alt%3D%22MSDataExposed.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1754908%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

Capacity planning plays a critical role in migrating an existing application or designing a new one. In the final part of this three-part series with Silvano Coriani, we'll review various Azure SQL capacity planning scenarios, as well as review best practices and recommendations on what to use when.

 

For an overview of Azure SQL Capacity planning, watch part one.

To learn about the differences between DTU and vCore, watch part two.

 

Watch on Data Exposed

 

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

 

View/share our latest episodes on Channel 9 and YouTube!