question

gamakgaraj-6982 avatar image
1 Vote"
gamakgaraj-6982 asked MANTOVANIFrancesco-7823 answered

Correlation between Azure VM to Azure SQL

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.

azure-sql-databaseazure-sql-virtual-machines
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@gamakgaraj-6982

The first thing you should check while migrating is what Purchasing models are available. If you understand the language of CPU and Memory - look at the V Core Purchasing model which is closer to what we have right now on-Prem

The DTU model is combined measure of CPU+Memory and more info is the document tagged. Please go through these documents and please get back to us for any questions.

Regards
Navtej S


1 Vote 1 ·

Thank you. Got it

0 Votes 0 ·
MartinCairney-6481 avatar image
1 Vote"
MartinCairney-6481 answered gamakgaraj-6982 commented

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MANTOVANIFrancesco-7823 avatar image
0 Votes"
MANTOVANIFrancesco-7823 answered

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.