Post navigation

Sizing your Azure SQL Database

Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your Azure SQL Database? How would you go about it? Would you use the DTU (Database Transaction Unit) calculator? What about the new pricing model vCore? How would you translate you current on-premises workload to the cloud?

It can be a form of trial and error especially if you are new to this but I really do recommend trying out the PowerShell script that you can access once you have installed DMA – Database Migration Assistant.

The process is two-fold. Call the PowerShell script to run where it will capture important data via perfmon counters and even via T-SQL. You will then take the output in the form of a CSV file and run a second command to give you a report. You can find the script at the following location: C:\Program Files\Microsoft Data Migration Assistant\which you will need to CD to.

Anyways, back to the main post. You will want to run this when there is a true reflection of your on-premises SQL Server work-load to paint a true picture. Once it completes expect to see a CSV file. We need that CSV file as input.

This is what you can expect from the HTML file. These are minimum recommended levels.

I have 2 databases where one is recommended to be set at S0 10 DTUs using the DTU model and the other General Purpose Gen 5 using the vCore model. If you want to see some reasoning or I should say, the tools’ thought process check the TSV file. For example, it says that for my rsc_test database that “this database appears to have very light traffic. It will be most cost-effective to host it on the Standard Tier”. I know this is quite true.

You can also use the sliders to get an idea of the costs too. Lets say for my rsc_test database that I want a P1 service tier and compute size it will adjust the pricing.