Reporting Services too slow.

Every time I log in for the first time in my Reporting Services by IIS it′s take forever.

Can I do something for increase the speed of this first connection to Reporting Services? After the first one the Reporting Services is much more faster.

Hello,

I believe the problem is your application pool is set to recycle too often. Take a look at this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1619105&SiteID=1

Hope this helps.

Jarret

|||Thanks... helped!

Reporting Services too slow.

Every time I log in for the first time in my Reporting Services by IIS it′s take forever.

Can I do something for increase the speed of this first connection to Reporting Services? After the first one the Reporting Services is much more faster.

Hello,

I believe the problem is your application pool is set to recycle too often. Take a look at this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1619105&SiteID=1

Hope this helps.

Jarret

|||Thanks... helped!

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

Reporting Services Rendering is Slow

I use the web service as well as intergrated url link to display, but both
display the same characteristics. The first run is extreemly slow. We
could be talking up to 1 minute to generate a pretty basic report.
When the same report with a differnet parameter or even a different report
is run the display is immediate.
The server it sits on has not been rebooted, but if i run the same report
the next day then it runs as if its the first time its run.
Is there some kind of setting I've missed in IIS or SRS that is obviously
unloading all the compiled referneces to SRS. I understand that .net
application are slow on first execution due to compiling etc.
Can anyone help?the first time you access Reporting Service, IIS must compile the webpages.
a w3wp process starts and compile the page and then start the rendering.
after some times, the application pool is killed to released the resources
on the server.
So go in your application pool (in IIS) and change the recycle parameters.
and also you can create a scheduled task to wakeup Reporting Services.
"Namshub" <Ricchard.Pullen@.Southend.nhs.uk.RemoveMyspam> wrote in message
news:Oi#tWk8iHHA.4516@.TK2MSFTNGP03.phx.gbl...
>I use the web service as well as intergrated url link to display, but both
>display the same characteristics. The first run is extreemly slow. We
>could be talking up to 1 minute to generate a pretty basic report.
> When the same report with a differnet parameter or even a different report
> is run the display is immediate.
> The server it sits on has not been rebooted, but if i run the same report
> the next day then it runs as if its the first time its run.
> Is there some kind of setting I've missed in IIS or SRS that is obviously
> unloading all the compiled referneces to SRS. I understand that .net
> application are slow on first execution due to compiling etc.
> Can anyone help?
>
>|||maybe you should stop using MDB as a database
"Namshub" <Ricchard.Pullen@.Southend.nhs.uk.RemoveMyspam> wrote in message
news:Oi%23tWk8iHHA.4516@.TK2MSFTNGP03.phx.gbl...
> I use the web service as well as intergrated url link to display, but
both
> display the same characteristics. The first run is extreemly slow. We
> could be talking up to 1 minute to generate a pretty basic report.
> When the same report with a differnet parameter or even a different report
> is run the display is immediate.
> The server it sits on has not been rebooted, but if i run the same report
> the next day then it runs as if its the first time its run.
> Is there some kind of setting I've missed in IIS or SRS that is obviously
> unloading all the compiled referneces to SRS. I understand that .net
> application are slow on first execution due to compiling etc.
> Can anyone help?
>
>|||Snotty but not the reason. Note that it is the first time that he has
problems, not subsequent times. This is totally an IIS issue and the fact
that asp.net application (which is what RS is) gets unloaded.
Detailed instructions for solution is: Go to IIS Manager, under Applocation
Pools node, right click "DefaultAppPool" in which the Reporting Server work
process is running, select properties. On "Performace" tag, you will see,
by default, the app pool will shut down if > being idle for 20 min. You can
extend this time to 8x60min 480min, so that the app pool will not shut down
for a regular working day. However, the first report reader of the day,
will hit the delay. You may schedule a dummy report at beginning of a work
day for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Aaron Kempf" <akempf@.dol.wa.gov> wrote in message
news:uAzPTfdjHHA.208@.TK2MSFTNGP05.phx.gbl...
> maybe you should stop using MDB as a database
>
> "Namshub" <Ricchard.Pullen@.Southend.nhs.uk.RemoveMyspam> wrote in message
> news:Oi%23tWk8iHHA.4516@.TK2MSFTNGP03.phx.gbl...
>> I use the web service as well as intergrated url link to display, but
> both
>> display the same characteristics. The first run is extreemly slow. We
>> could be talking up to 1 minute to generate a pretty basic report.
>> When the same report with a differnet parameter or even a different
>> report
>> is run the display is immediate.
>> The server it sits on has not been rebooted, but if i run the same report
>> the next day then it runs as if its the first time its run.
>> Is there some kind of setting I've missed in IIS or SRS that is obviously
>> unloading all the compiled referneces to SRS. I understand that .net
>> application are slow on first execution due to compiling etc.
>> Can anyone help?
>>
>