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 madein 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表格模型
发布评论