Slow report processing
Hi everyone, I'm having a problem with the speed of reporting services. When I execute the report in SSRS, it takes about 15 seconds for a report to show on the webpage, while the query only takes a fraction of a second. Some more details: The query is a stored procedure Report only contains a table and some labels; no charts or other fancy stuff is involved The query returns 140 rows In Sql Server management studio, the query displays an execution time of 00:00:00 The ExecutionLog in the ReportServer database shows the following: TimeDataRetrieval=118 TimeProcessing=33 TimeRendering=569 (all together still less than a second) Perfmon shows that the delay is caused by processor activity; not the physical disk The Sql Server instance is 2008 R2 and uses 2 processors and has 1.5 GB of memory available I don't know how I can further determine the source of the performance problem. I do suspect that it is some kind of throttle setting for reporting services, but it's just an idea. Does anybody know what I can do or know a good link that can help me? Thanks, Stefan
November 12th, 2010 8:16am

Hi Stefan, "•The ExecutionLog in the ReportServer database shows the following: TimeDataRetrieval=118 TimeProcessing=33 TimeRendering=569 (all together still less than a second) " The above total time is close to time taken to run the report on the server. On the client side, time taken to transport the report data via network and web rendering is not involved. So, the time might be more long than the execution log. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 1:13am

Hi Jerry, I'm running the report on the server machine itself, so there shouldn't be any network traffic at all. I did manage to reduce the time it takes to run a report to approx. 7-8 seconds by setting the db owner for the ReportServer, ReportServerTempDb and my reporting database to sa. They were initially set to a domain administrator's account. But still, 7-8 seconds seems too much to me because we have another customer that has the same reports, and they only take 4-5 seconds to render. That other customer has a similar physical machine, has much more data in the database and even has additional database applications running on it. The only apparent difference between the 2 customers that I can think of is that the faster one is running on Sql Server 2008, instead of 2008 R2. Do you know if there is a way to check the time it takes for the client to render the report? Or if there are any other timings that I can check? Such as the time it takes to authenticate for example. Thanks for helping Stefan
November 16th, 2010 2:53am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics