问题描述
我正在使用 MS Reporting Services 2016.我注意到 应用程序域默认设置为每 12 小时回收一次.现在,回收后对用户的影响要么是报告服务响应缓慢,要么是报告失败.刷新报表后两者都会消失,但这并不理想.
I'm working with MS Reporting Services 2016. I noticed that the application domain is set by default to recycle every 12 hours. Now the impact on users after a recycle is either slow response from reporting services or a failed report. Both disappear after a refresh of the report, but this is not ideal.
我遇到了一个 SO 答案,人们建议 您可以通过设置配置属性 RecycleTime 来关闭计划的回收
归零.
I have come across a SO answer where people suggest that you can turn off the scheduled recycle by setting the configuration attribute RecycleTime
to zero.
我还阅读了编写脚本以手动重启报告服务,这也回收了应用程序域.然后是一个 脚本,它只是在受控时间加载报告 删除第一次加载问题.然而,这一切对我来说似乎都是一种解决方法,我宁愿不必这样做.
I have also read that writing a script to manually restart reporting services, which also recycles the app domain. Then a script that simply loads a report at a controlled time to remove the first time load issues. However this all seems like a work around to me and I would rather not have to do this.
我担心的是,安排回收时间必须有合理的理由,但我找不到任何信息来解释这一点.有谁知道关闭预定的应用程序域回收是否有负面影响?
My concern is that there must be a logical reason for having the scheduled recycle time, but I cannot find any information explaining this. Does anyone know if there is a negative impact from turning off the scheduled application domain recycle?
推荐答案
RecycleTime
是一个函数,旨在确保 SSRS 不消耗它不需要的 RAM,并可能使其余的内存挨饿机器.禁用刷新基本上会取消收回用于短暂密集处理的任何内存的能力.
The RecycleTime
is a function aimed at making sure SSRS isn't consuming RAM it doesn't need and potentially starving the rest of the machine. Disabling the refresh essentially removes the ability to claw back any memory used for a brief period of intensive processing.
如果你确信你的机器有适当的资源,你可以关闭刷新,或者,如果没有,或者将刷新安排在几个小时之外,并定义一个缓存刷新计划
来缓存任何超级之后立即报告重要报告,以尽量减少对用户的影响.
If you are confident your machine is suitably resourced you can turn the refresh off or, if not, alternatively schedule the refresh for an out of hours time and define a Cache Refresh Plan
to cache any super important reports immediately afterwards to minimise any user impact.
在此处进一步阅读:https://www.mssqltips.com/sqlservertip/2735/prevent-sql-server-reporting-services-slow-startup/
这篇关于为什么SSRS需要回收应用域的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!