Correlation between Azure VM to Azure SQL

Question

Hi,

To reduce cost, I want to migrate SQL database from Azure VM to Azure SQL.
I found a lot of guides hot to do this. But I can't find information about tiers comparation. For example, I have VM with size D4 V4. What type for SQL server should I choose for migration? Basic 0? Standard 1? Something else?
I have 10 VMs with different sizes that I should migrate. I need understand what size of SQL Server should I choose to migrate databases from Azure VM to Azure SQL.

Answer 1

Your best way to get the estimate for the Service Tier needed is to make use of the Database Migration Assistant - there is a script part of this that allows you to estimate the SKU. See here

It involves gathering PerfMon metrics from your existing VM and then does a comparison on the Tiers to provide the starting point.

You will also want to run the compatibility assessments to see if there are any blockers to migrating to Azure SQL DB

Answer 2

There is this page that will allow you to calculate the right DTUs for the whole VM.

Keep in mind it will calculate the charge for the whole VM not the single DB.