问题描述
我已经安装了 SQL 报告服务器 (2008 R2),其中包含一些报告.但我有一些表演问题.
I've installed a SQL Reporting server (2008 R2), with some reports. But I've some performances issues.
当天对服务器的第一次调用(通过示例进入报告界面)非常慢(最多大约 30-45 秒).
The first call of the day to the server(going on the report interface by example), is VERY slow(something like 30-45seconds at best).
报告生成速度很快(1-2 秒).
The report generation is then "fast"(1-2 seconds).
对服务器的下一次调用总是断食直到第二天.我的印象是它在内存中加载了很多东西.但是什么需要 30-45 秒才能加载到内存中???以及如何只加载一次?
The next calls to the server are always fasts until the next day. I've the impression that it loads a lot of thing in the memory. But what can takes 30-45 seconds to be loaded in memory??? And how to load it only once?
服务器足够好(四核,8GB 内存,目前还没有接近其容量).
The server is good enough(quad core, 8GB of ram, never near its capacity for now).
有什么问题?我该如何解决?
What is the problem? How can I resolve this ?
这些报告将在一周内仅发布 4-5 次,因此如果我无法更改这一点,它们将总是很慢.而且由于它可供客户使用,我无法让他们理解这一点(并且报告是通过网站调用的,所以我有超时的风险).
Thoses reports will be launched only 4-5 times in a week, so they will always be slow if I can't change this. And since it's available for customer, I just can't make them understand this(and the report is called through a website, so I risk to have timeout).
非常感谢
推荐答案
这似乎是一个 SSRS 问题.你的报告没有任何问题.
It seems to be an SSRS issue. There is nothing wrong with your report.
长时间不活动后,SSRS 在您第一次访问时需要更多时间来加载,这是正常的".该问题是由 SSRS 的工作方式和 SSRS 在特定时间段后定期重新启动应用程序域的方式引起的.应用程序域重启后,第一次向SSRS请求时需要加载所有设置,需要很长时间.
It's "normal" that SSRS takes more time to load the first time you access it after a long time of inactivity. The issue is caused by the way how SSRS works and SSRS regularly restarts application domain after a specific time period. After the application domain is restarted, then upon first request to the SSRS it needs to load all the settings and it takes quite a long time.
这个博客显示是一种解决方法
This blog show's a workaround for the situation
这篇关于SQL 报告服务:第一次调用很慢的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!