报告服务速度缓慢
好的，我有一份由 SQL Server 2005 支持的 Reporting Services 2005 报表。
我使用一些 C# 代码生成 10 条记录。也许 12 列。表中只有 6500 条记录。
我将这些记录记录到数据库中，然后简单地显示它们。因此，据我所知，报告服务器没有进行任何计算或任何激烈的事情。
这些记录于今天下午 3:57 在数据库中创建。现在是下午 4 点 11 分。运行时间始终需要 15 - 30 分钟。
现在，服务器硬件相当不错（12 GB、4 核等）。但它的负载相当重。所以我猜这是问题的一部分。
但我能做些什么来帮助加快这个过程吗？它永远位于“正在生成报告”圆圈中。
谢谢。
编辑： 我忘了提及我确实在 RS 用于获取的列上设置了索引。
OK, I have a report in Reporting Services 2005 backed by SQL Server 2005.
I use some C# code to generate 10 records. Maybe 12 columns. There are only 6500 records in the table.
I record those records to the database and then simply display them. So the Reporting Server isn't doing any calculations or anything intense that I can tell.
The records were created in the DB at 3:57PM today. It's 4:11PM now. It's consistently taking 15 - 30 MINUTES to run.
Now, the server hardware is pretty good (12 gigs, 4 cores, etc). BUT it is under pretty heavy load. So I'm guessing that is a part of the problem.
But is there anything I can do to help speed up this process? It sits on the "Report is being generated" circle forever.
Thanks.
EDIT:
I forgot to mention I do have indexes setup on the column RS uses to fetch.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
问题解决了。我们转移到更快的服务器。我们发现现有服务器被其他服务关闭。
Problem solved. We moved to a much faster server. We found that the existing server was being brought down by other services.