开发者

SQL 2005 Reporting Services seems to process reports sequentially

I'm trying to profile the experience of multiple users of a web application, all trying to generate reports at the same time. The reports are displayed on a web page using the report viewer control. The execution log on the re开发者_运维问答port server seems to indicate that the reports are executed sequentially (one at a time).

Is this the expected behavior?

Is there a way to tweak this behavior? Maybe some configuration file on the report server. Or something in the way the requests for the reports are issued?

I know I can use report caching, and optimize the report execution itself. But I need to address the case where multiple users ask for a "fresh" copy of their report (different for each user), and the report execution takes 30-60 seconds.

Is there any other technique to speed things up?


Can you check you have accidentally checked the User Single Transaction option on the data source.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜