August 20, 2010 at 9:40 am
Hi everyone,
I have a couple of simple reports that I created just to demonstrate to someone how the ReportViewer control works in Visual Studio 2008. When I say simple, there aren't actually any data elements on the report at all. I just have a text box where I manually entered some text just to give them an idea what the report would look like. (I'll be developing the actual report at a later date.)
The weird thing is that, whether I'm using the ReportViewer control in VS or just opening Report Manager in IE, it takes a really long time to load only the first time it's called after being "idle" for a long time. After that, it renders quickly as it should.
Is there some sort of setting that makes the SSRS web service or IIS go to sleep after a while? I know that sounds silly, but that's what it seems like.
By the way, this is SSRS on SQL 2005. ReportViewer in VS 2008, and Report Manager viewed on IE7.
Thanks.
Kris
August 20, 2010 at 10:49 am
The typical culprit is settings for the application pool that SSRS is using inside of IIS. The usual culprit is the Recycle on Idle Timeout setting for the Application Pool. Uncheck that and you should be all set. there will still be the roughly 30 second slowness on the first report run after a reboot or service restart, but for the most part you shouldn't see the issues you currently are during normal usage.
Since SSRS is a .Net application as the assemblies are being built the first time the web garden spins up it takes a while to compile and process the first request, after which it is pretty quick. More info here.
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply