Wednesday, March 28, 2012

Reporting Services Slow to wake up

My users have been complaining that the first time they run reports on Reporting Services during the day it takes 30+ seconds for the first report to run. After this initial delay they respond very quickly.

There is considerable interaction with the database through a client application prior to this so the server is not in a sleep mode. It appears to only be an issue with Reporting Services.

Any ideas on how I can get this initial delay to go away?

Thanks in advance.

If the user is accessing reports through Report Manager, reporting services relies on IIS to host it in an AppDomain. IIS will often take several seconds (duration depending on the current use and speed of the machine) to intialize this AppDomain. You can adjust the timeout period of the Report Server AppDomain through IIS. This would minimize the number of startups that have to occur.

Thanks, Jon

No comments:

Post a Comment