You are planning cloud migration and wondering what should be the T-shirt size of your SQL Server in IaaS or Azure SQL/MI in PaaS. You are concerned if your workload be able to scale without making a hole in your company’s pocket!
Well, understanding the workload of your data intensive application and performance capabilities of Azure SQL is the first and very important stage. Based on the workload you need to pick T-shirt size or SKU/Service tier.
Picking right T-shirt size save cost, result into better performance, enough room to scale and less performance issues for your DBAs.
In this demo centric session, I will show you how to calculate your on-prem or cloud data workloads and pick a correct T-shirt size using various methods and tools like DMA, Query Store, DMVs.