Monday 20 February 2017

MS Azure : SQL Database DTUs Calculator

Azure SQL Database DTUs Calculator


If we want to migrate SQL Server Database which is running on VM Server to Azure SQL Database. How can we know, how many DTUs are required?
So for an initial estimate, there is a DTUs calculator at http://dtucalculator.azurewebsites.net/ developed by Justin Henriksen, Azure Solution Architect at Microsoft.
Once you open this DTUs Calculator, we will find both models calculator (Single Database & Elastic Pool model).

DTUs Calculator Workflow


Here are the high level steps to calculate the required DTUs to migrate the Database:
Step 1 : Run the Trace on database server atleast for an hour or when the database is highly utilized and Collect the performance trace output.


Step 2 : Upload the trace file to the DTU calculator website, mentioning the no. of cores on the current Server.


Step 3 : DTU calculator will give you the result and we have to analyze and start with estimated DTU configuration.


Note : This is just a way to identify the estimate DTUs required to migrate database, not the actual DTUs.

1 comment:

  1. Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on. SQL server dba Online Training

    ReplyDelete