SQL Azure的数据仓库DWU VS SQL Azure的DTU [英] Azure SQL Data Warehouse DWU vs Azure SQL DTU

问题描述

我正在考虑从Azure的SQL天青SQL数据仓库迁移。这似乎提供了一些我们需要的功能，但是价格是首发小关注。 100 DWU数据仓库的售价相当高（ $ 521 /月），比一个看似可比的100 DTU SQL Azure的一线S2（ $ 150 /一个月）。

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).

要确保我比较苹果和苹果，可有人阐明DWU如何比较DTU一些轻（假定与单个数据库基本配置）？

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)?

编辑：大家谁是倾向于回答Azure的SQL数据仓库和Azure的SQL没有可比性，因此没有意义的DTU比较DWU：那么它是如何有意义（的谈移民）到DW？

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?

推荐答案

有关它的价值，1 DWU = 7.5 DTU相对于服务器容量

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

当你在服务器实例，你准备在DW实​​例：

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

• 100 DWU实例消耗的服务器容量750 DTU的


• 400 DWU实例占用的服务器容量3000 DTU的

虽然这个信息是有趣的，它可能不是因为DW定价完全基于DWU是在比较价格方面非常有用，而SQL Azure的定价是DTU和数据库大小的组合。

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.

这篇关于SQL Azure的数据仓库DWU VS SQL Azure的DTU的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！