We have an issue moving from SSRS 2008 to SSRS 2008 R2.
A report on SSRS 2008 server runs in 5 or 10 seconds. When I deploy it to our 2008 R2 server, it takes around 5 MINUTES to run!
I reckon this is a bug in SSRS 2008 R2, and would like some feedback from other users.
Could some of you please deploy the attached report to your 2008 and/or 2008 R2 servers and let me know how long it takes to view the report from a browser?
I have attached the report as TestPerf.txt (you'll need to change the extension to RDL).
Thanks in advance.
What makes you think it is a bug? What does the execution plan for each instance show you?
When I reviewed the plan I got from the query it shows the "Optimization Level" as "TRIVIAL". What I have read this simply means the query is not going through the full optimization process by the optimizer due to certain requirements. I don't have a SQL 2008 instance but ran the query on SQL 2008 R2 (SP1) and SQL 2005 (SP4) and got the same plan and same time to run it. I don't have a report server to deploy it to.
answered Apr 17 '12 at 06:28 PM