We have a SSRS 2008 implementation. We are finding reports that take a long time to render via the reportserver links. In the ExecutionLog2, the correlating data retrieval, processing, and rendering times are all fast, usually under 2 seconds, and often cached... so almost immediate. Yet depending on the report, it will not show via report server for some time... up to two minutes.These are not large reports. Page breaks (where applicable) seem to be appropriately placed.

I've checked networking, and speed between servers is fine. I have even run report server locally on the SSRS machine and still receive the same delay.The SSRS server has plenty of RAM and CPU. Utilization stays low. Disk latency is low.

What fundamental element am I missing here?

Thanks for everyone's time!

Have you tried running these reports in BIDS and have you noticed the performance ?

Where is your SSRS report manger deployed and from which box are you trying to access your server?

What browser versions are you using ?

Are there any expressions on the report ?If so how many and can you elaborate on them?

Hi Randy,

Based on your scenario, I would give you steps to troubleshoot this unusual performance issue:

You can make use of the Trace Log, when you need to troubleshoot report server operations, you can review Trace Log generated by Reporting services. Trace logs include records application log events, errors and exceptions, low resource warnings, report delivery details, and other details about reporting services operations. You can use any text editor to view the file. This file is located at \Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles. For more information about Trace log please seehttp://msdn.microsoft.com/en-us/library/ms156500(v=SQL.105).aspx 

In addition, you can make use of Performance counter to monitor report server, this counter can help you understand how reporting services is using system resources during on-demand or scheduled report execution. Reporting services includes the following performance objects:

For more information about Windows Performance Counters, please see: http://msdn.microsoft.com/en-us/library/ms159809(v=SQL.105).aspx

Currently, if this issue are urgent to your business, you could also contact Microsoft Customer Support Services (CSS) via telephone so that a dedicated Support Professional can assist you in a more efficient manner. However contacting phone support will be a charged call. but it will be free if this is a product issue.

To obtain the phone numbers for specific technology request please take a look at the web site listed below. http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

Have you tried running these reports in BIDS and have you noticed the performance ?

Where is your SSRS report manger deployed and from which box are you trying to access your server?

What browser versions are you using ?

Are there any expressions on the report ?If so how many and can you elaborate on them?