问题描述
您好,我有一份SQL 2016 SSRS报告从同一台服务器上的SSAS 表格多维数据集中提取数据。报告的运行时间更长,您能否为SSRS和SSAS方面提供任何性能配置/最佳实践建议?这些是新建的
,RS和AS都位于同一台服务器上。另请告诉我如何查找查询并在可能的情况下调整它们。
Hi there, I have a SQL 2016 SSRS report pulls data from SSAS tabular Cube on the same server. The report running way longer, can you please suggest any performance configurations/best practices for SSRS and SSAS side? These are newly built and both RS and AS sit on the same server. Also let me know how do I find out the query and tune them if possible.
谢谢
推荐答案
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/dn393915(v = msdn.10 )
或者您可以在SSRS报告服务器中部署报告,然后检查executionlog3(SSMS-> reportserver database-> View-> Executionlog3)以查看哪个部分花费更多时间。您可以参考
了解详情
最好的问候,
将
Or you could deploy the report in SSRS report server , then check executionlog3(SSMS->reportserver database->View->Executionlog3) to see which part cost more time. And you could refer toTroubleshooting Reports: Report Performance for details
Best Regards,
Will
这篇关于SSAS / SSRS查询性能选项的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!