SSAS表格模型 - 使用多个度量执行查询并不是并行的？ [英] SSAS Tabular Model - Execution of query with multiple measures are not in parallel?

问题描述

Hello All，

Hello All,

我查询了一个度量"A"。执行需要600毫秒。

I have query with one measure "A". it takes 600 ms to execute.

同样，其他措施"B"也是如此。和"C"表示"C"和"C"。执行时也需要大约600 ms。

Similarly, other measures "B" and "C" also takes approximate 600 ms to execute.

当在同一查询中使用所有三个度量时，执行需要1400-1800毫秒。 SE和FE中的所有度量执行都不是并行的。

When all three measures are used in same query, it takes 1400-1800 ms to execute. All the measure execution in SE and FE are not in parallel.

当我们使用10种不同的度量时，大约需要6秒。

When we use 10 different measures, it takes approximately 6 seconds.

如何使用多个度量时的性能查询？我们如何能够并行执行多项措施？

How the performance query when multiple measure are used? How can we get the execution of multiple measures in parallel?

感谢您的支持。

推荐答案

嗨Ravi，

感谢您的帖子。

根据你的描述，我猜你可能出错了方向。我没有听说过可以同时执行多项措施。但我知道在SSAS多维模式下并行处理选项，在

Per your description, I guess you probably go wrong direction. I haven't heard that execution of multiple measures could be made in parallel. But I know processing option parallel in SSAS multidimensional mode, which is described at

SQL Server Analysis Services处理订单选项

此外，在SSAS表格模式下，它只有并行分区处理功能。

Also, in SSAS tabular mode, it just has parallel partition processing feature.

最好的问候，

将

这篇关于SSAS表格模型 - 使用多个度量执行查询并不是并行的？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！