How long does this report take on your SSRS 2008 R2 server?


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][1] (you'll need to change the extension to RDL).

Thanks in advance.

[1]: http://ask.sqlservercentral.com/storage/temp/174-TestPerf.txt
TestPerf.txt (28.6 kB)
more ▼

asked Apr 17, 2012 at 04:25 PM in Default

xnl28 gravatar image

895 56 60 62

Have you take a look on the executions statistics stored in the [ExecutionLogStorage] table in the Report Server database?

If not, take a look on the TimeDataRetrieval, TimeProcessing and TimeRendering to find out what causes the long execution.
Apr 17, 2012 at 06:37 PM Pavel Pawlowski
@Pavel: Yes, I checked all those figures before posting the question. The total of TimeDataRetrieval, TimeProcessing and TimeRendering averages about 2 or 3 seconds over several runs. So the huge time in 2008 R2 is due to Internet explorer rendering the report (not the server rendering the report)
Apr 17, 2012 at 06:58 PM xnl28
@xnl28 Did you seek help from Microsoft? (You said you will in earlier thread) If yes, then what is the response you got?
Apr 18, 2012 at 04:37 AM Usman Butt
@xnl28 First thing noticed in your report is that Tablix's "KeepTogether" property is set to TRUE, which means that you want all your data on one page? This itself could decrease the performance. Try setting that property to FALSE and please let us know the result.
Apr 18, 2012 at 10:09 AM Usman Butt

It is simple because there is a bug in 2008 R2. If you cannot live with the workarounds then wait for a CU/Service Pack OR whatever the Microsoft suggests.

Having said that, I would request not to post new questions with the same. You can always update your pending threads to seek help. This way everyone would have the background readily available and can give you better support. Thanks.
Apr 18, 2012 at 11:34 AM Usman Butt
show all comments (comments are locked)
10|1200 characters needed characters left

6 answers: sort voted first
I think we're seeing the same issue over here. The reports run fine on 2008, but take excessive time in R2 and 2012. This effects the same IE 8 and 9, but Chrome runs very very fast.
more ▼

answered Jun 19, 2012 at 04:17 PM

benjamin.reyes gravatar image


(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 17, 2012 at 04:25 PM

Seen: 2380 times

Last Updated: Jun 21, 2012 at 12:36 PM