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.
Database Transaction Units (DTUs)
A DTU is a unit of measure of the resources that are guaranteed to be available to an Azure SQL database at a specific performance level.
DTU is measures how powerful is your database is, but how it measures ?
DTU is measured based upon the resource utilization by the database:
Blends CPU + Memory + Data I/O + Log I/O
It is based on a Microsoft OLTP benchmark. It is useful unit of comparison.
So basically in short, Higher DTUs provide higher throughput.
Changing Tiers :
You can move/change database from a lower tier to a higher tier or vice versa at any point in time.
There are few point which we have to keep in mind before changing the tier:
1. Duration of the change depends on the amount of data.
2. Your charges will change once the new tier is in effect.
3. You need to retry logic in your application according to DTUs usage (Resources utilization - CPU / Memory / Data & Log I/O).
For Example :
If we execute 10 Queries on both Tiers, result would be like as follows:
In Basic Tier a Database with 5 DTUs limit will complete 10 queries execution in 60 Seconds.
In Standard Tier a same Database with 100 DTUs limit will complete 10 queries execution in 3 Seconds.
Click here for the demo of changing tiers example in further posts.
