WHy does the Report manager take an age to open first thing in the morning

Question

WHy does the Report manager take an age to open first thing in the morning

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

DBADave-191366 Old Hand Points: 365 More actions · Answer 1

Reporting Services 2008 has the same first connection slowness, and it's not using IIS. Is there a fix or configuration change that can be made to it?

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 2

Hi Dave,

Although IIS does require some time to get an AppPool started up, my understanding with SSRS was that it was actually the JIT (re)compilation of the app that causes the initial delay. So the inclusion or exclusion of IIS may save you a few precious milliseconds but you're always going to have to wait for that csc.exe process (the csharp compiler) to run. I would recommend setting up an app that makes a single call to either reports or reportserver. It would be nice if SSIS web service task supported the SSRS wsdl, but alas no (not until next major release they say). But until then, you could use this approach of using the Script task in SSIS to talk to the webservice (somewhat arbitrary which call you make, maybe ListChildren on the root would awaken the giant), schedule the package to run daily @ 5am (or whatever time will be prior to your first user hitting it), and then this should mean the service is up and awake. You could even schedule it to run hourly, to ensure the service is up. If the service itself isn't started, you could also add an execute process task, and perform a 'net start' to kick it off too.

Steve.