Thread: First hit to Reporting services is slow

Abba What does the query do? How much rows do you return? > Hello, > [quoted text clipped - 21 lines] > TIA, > AbbA

Uri, Its not about any single report or query. Its about slow loading of the Reporting service interface itself. For example, when I enter the url http://<servername>/Reports/Pages/Folder.aspx, it takes a while to bring up the page. Only the first time, after that it runs fine in the subsequent access. But again, after a long gap, the issue returns. > Abba > What does the query do? How ...

Odd, it could be to do with authenticating the user on the network. Does is take a long time when you logon to your domain ? How you would go about tracing and proving that though ive no idea. Dave Ballantyne http://sqlblogcasts.com/blogs/sqlandthelike/ > Uri, > [quoted text clipped - 34 lines] >>> TIA, >>> AbbA

This sounds very much like the app pools as you say below. It looks like you control this by using the RecycleTime. http://msdn.microsoft.com/en-us/library/bb934330.a spx It defaults to 12 hours. It looks like you can increase it. But, it might not be good for it to never recycle. You could schedule a report to run nightly so that first thing in the morning there isn't the lag. 6 minutes ...

Could it also be in part due to having to spin up all the .NET stuff for the first hit? Signature Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net > Hello, > [quoted text clipped - 21 lines] > TIA, > AbbA

It doesn't take a long time for autentication. Sorry, I forgot to mention it; that was the first thing my network admin checked. Thanks for the thought, Dave! > Odd, it could be to do with authenticating the user on the network. > Does is take a long time when you logon to your domain ? [quoted text clipped - 43 lines] >>>> TIA, >>>> AbbA

Thanks Bruce. I had gone through your recommendation regarding App pools in another article before posting. Thats why I specifically mentioned about not having IIS ..:) I have scheduled a dummy report to run before prod hours. As of now, Iam not touching RecycleTime. I will let you know if the dummy report helps the cause. > This sounds very much like the app pools as you say below. It ...

The dummy reports helped. Thank you Bruce! > Thanks Bruce. I had gone through your recommendation regarding App pools > in another article before posting. Thats why I specifically mentioned [quoted text clipped - 44 lines] >>> TIA, >>> AbbA

Good. A bit primitive way of solving it but sometimes that is what works. Signature Bruce Loehle-Conger MVP SQL Server Reporting Services > The dummy reports helped. Thank you Bruce! > [quoted text clipped - 47 lines] >>>> TIA, >>>> AbbA