SSRS Slow Waking Up On First Report

Greetings,

I continue to see this similar post all over the place, but no resolutions.

We have SSRS installed and operational in production. There are reports that get accessed from either an aspx page or from the built in IIS site for SSRS.

First time access is the performance problem. Here are two scenarios:

1) from your browser, pull up the front page to SSRS: http://myserver/reports. This simple operation will take about 2 minutes to come up. Drill to the report in question and it runs fairly well first time through. Throw a different query at it and it runs faster. If you wait a while (maybe 15 minutes +) the whole thing will spin back down and take 2 minutes to come up again. If you exit the website and come back immediately, everything still stays quick.

2) from an aspx page, same thing... if the service is spun down, the end user will typically get tired of waiting or timeout. Once everything is spun up, the process runs fine.

We setup another report that just does some simple statistics and added in a timed subscription for every 15 minutes hoping it would keep the service up and running.... no joy. Still the same.

Also adjusted the app pool to about every option to see if we could keep it running, but no joy.

====

So -- any ideas? Forget about running a report.... just think about pulling the website up. 2 minutes to get it to display in the browser the first time...

arghhhhhh

Thanks in advanced.



Dan Ribar