1个计算节点仅映射到Azure DWH中的1个分发，为什么我们需要DMS? [英] 1 compute node only map to 1 distribution in Azure DWH and why we need DMS?
问题描述
大家好，
我浏览了有关DWH的Azure文档，并在理解体系结构时遇到了一些困难.
I went through Azure documentations about DWH and had some difficulties understanding the architecture.
来自Azure文档
当SQL数据仓库时运行一个查询，该工作分为60个并行运行的较小查询. 60个较小的查询中的每个查询 在数据分布之一上运行.每个计算节点管理60个分布中的一个或多个.具有最大计算资源的数据仓库每个计算节点都有一个分布.计算资源最少的数据仓库具有所有分布 在一个计算节点上.
When SQL Data Warehouse runs a query, the work is divided into 60 smaller queries that run in parallel. Each of the 60 smaller queries runs on one of the data distributions. Each Compute node manages one or more of the 60 distributions. A data warehouse with maximum compute resources has one distribution per Compute node. A data warehouse with minimum compute resources has all the distributions on one compute node.
让我们举3个例子
-1个计算节点->有60个分布
-30个计算节点->也有60个分布-60个计算节点->也有60个发行版
- 30 compute nodes -> also has 60 distributions- 60 compute nodes -> also has 60 distributions
每个计算节点具有1个分配有什么好处?
What's the benefit of having 1distribution per compute node?
推荐答案
Khoi-Thinh
Khoi-Thinh
这时总是有60个发行版.
At this time there are always 60 distributions.
1个计算节点-> 1个节点具有60个分布
1 Compute Node -> 1 node having 60 distributions
30个计算节点->每个节点有2个分布
30 Compute Nodes -> each node has 2 distributions
10个计算节点->每个节点有6个分布
10 Compute Nodes -> each node has 6 distributions
60个计算节点->每个节点有1个分布
60 Compute Nodes -> each node has 1 distribution
希望对您有帮助！
谢谢
这篇关于1个计算节点仅映射到Azure DWH中的1个分发，为什么我们需要DMS?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
