All geek questions in one place

Azure SQL Data Warehouse DWU vs Azure SQL DTU

I am considering migrating from Azure SQL to Azure SQL Data Warehouse. It seems to offer some of the features we need, but the price is a problem for launching small ones. The 100 DWU Data Warehouse is priced significantly higher ( $ 521 / month ) than the seemingly comparable 100 Azure SQL S2 DTU ( $ 150 / month ).

To make sure I'm comparing apples to apples, can someone shed some light on how DWU compares with DTU (assuming a basic configuration with one database)?

Edit: anyone who is inclined to answer that Azure SQL DW and Azure SQL are not comparable, and therefore it makes no sense to compare DTUs with DWUs: then how does it make sense ( talking about migration ) to DWs?

+4
source share
3 answers

What is 1 DWU = 7.5 DTU for server capacity?

When you look at a server instance in which you are specifying a DW instance:

  • 100 DWU instances consume 750 server capacity DTUs
  • 400 DWUs consume 3,000 DTU server capacity

Although this information is interesting, it may not be very useful in terms of price comparisons, since DW pricing is based solely on DWUs, and Azure SQL pricing is a combination of DTU and database size.

+5
source

; , . , DTU DWU . , ? , (, TSQL ?)

Azure SQL DB DB . , Azure SQL DB , SQL Server, . OLTP ( ), ( , SQL DB).

SQL DW , . MPP . OLTP, , , . SQL DW, , SQL DB.

SQL DW TSQL, , concurrency, ( OLTP) .., , . , , , OLTP. / SQL DW.

+3

The best way to find out what you need is to look at your current IO requirements. Data warehouses are typically IO hogs and therefore optimized by maximizing I / O throughput. On the DWU Calculator website, you look at the process of capturing the metrics of your disk and estimate how many DWU you need to complete your workload.

http://dwucalculator.azurewebsites.net/

0
source

Source: https://habr.com/ru/post/1614627/

More articles:


All Articles