We are in the process of migrating our SSRS 2005 reports onto a new SSRS 2008 server. We are seeing execution times of the same reports on each server considerably slower on the new server. A sample large report I've used for benchmarking by scheduling it to run hourly over a day typically runs in 4-5 minutes on the old server and in 20-25 minutes on the new server. Wheras is I run the query itself on each server through management studio they both do it in about 3 minutes. This suggests to me that the problem is prbably ion the configuration of the report server. There is no hardware or operating system difference between the two that could account for the differencem, if anything the new server should be faster. I know in 2005 there where IIS tweaks that improved performance but assume these no longer apply in 2008 as IIS is not used. Can anyone suggest articles on what settings etc I should be looking at to resolve this? Thanks BruceBruce < a href="http://homepages.woosh.co.nz/bf/">http://homepages.woosh.co.nz/bf/

Hi, I would recommand you follow this article http://blogs.msdn.com/b/robertbruckner/archive/2009/01/05/executionlog2-view.aspx to analyze your report with comparing their timedataretieval,timeprocessing, timerendering and source(live or cache). For the big difference, did the report have caching in the SSRS 2005? To improve processing performance, one way is to cache report. See http://msdn.microsoft.com/en-us/library/ms155927(v=SQL.100).aspx for report caching in reporting srvices. thanks, Jerry

No the report was not cached in 2005, the issue is not with one report but with all reports, so the issue is with the server. The example report was created specifically to test performance so that we could be confident it was exactly the same on each server. We shouldn't have to cache reports as a workaround when a server isn't performing as expected. Bruce http://homepages.woosh.co.nz/bf/