Azure SQL Data Warehouse DWU vs Azure SQL DTU

Question

I am considering migration from Azure SQL to Azure SQL Data Warehouse. It seems to offer some of the features that we need, however price is a concern for starting small. 100 DWU Data Warehouse is priced considerably higher ($521/month) than a seemingly comparable 100 DTU Azure SQL S2 tier ($150/month).

To make sure I am comparing apples to apples, can someone shed some light on how DWU compare to DTU (assuming basic configuration with a single database)?

Edit: to everyone who is inclined to answer that Azure SQL DW and Azure SQL are not comparable and therefore it makes no sense to compare DTU to DWU: then how does it make sense to (talk about migration) to DW?

Answer 1

For what it's worth, 1 DWU = 7.5 DTU with respect to server capacity

When you look at the server instance that you provision a DW instance on:

• 100 DWU instance consumes 750 DTUs of server capacity
• 400 DWU instance consumes 3,000 DTUs of server capacity

While this information is interesting, it may not be very useful in terms of comparing pricing because DW pricing is exclusively based on DWU, while Azure SQL pricing is the combination of DTU and database size.