使用AMO对象处理时的性能 [英] Performance when processing with AMO objects
问题描述
美好的一天!
Good day!
我们正在使用.NET Web服务来处理SSAS中的多维立方体,分区和维度。我们一直在衡量管理工作室中Web服务和直接处理之间的性能,差异非常大(SSMS中的5行维度
需要0秒,而Web服务需要10秒,只需维度处理,而不是整个网络服务。)
We're using a .NET web service to process multidimensional cubes, partitions and dimensions in SSAS. We've been measuring the performance between the web service and direct processing in Management Studio and the difference is quite large (a 5 row dimension in SSMS takes 0 seconds and in the web service takes 10 seconds, just the dimension processing, not the web service as a whole).
我们进行了一项测试,以并行处理所有维度,然后是多维数据集或分区。而不是下降,时间从一个维度的50-60秒变为600-700秒。
We made a test to process in parallel all the dimensions and, then, the cube or partition. Instead of going down, the time went from 50-60 seconds to 600-700 seconds just one dimension.
¿有两个方法之间的时间是如此不同的原因? Web服务位于同一SSAS服务器中,因此我们放弃了网络问题。
¿Is there a reason why the times between the two methods is so different? The web service is in the same SSAS server, so we discarded network issues.
问候,
推荐答案
嗨dany,
我不确定 是否由网络,内存或CPU引起。 此外,您可以尝试监控SSAS以查看哪个部分在处理过程中会花费更多时间 立方体或尺寸。您可以尝试参考提高
多维数据集处理时间和管理和监控Analysis Services 以获取详细信息。
I am not sure whether is caused by the network, memory or CPU. In addition, you could try to monitor SSAS to see which part will cost more time when process cube or dimension. You could try to refer to Improving cube processing time and Administering and Monitoring Analysis Services for details.
最好的问候,
Zoe Zhi
这篇关于使用AMO对象处理时的性能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!