First hit to Reporting services is slow

[Abba]

Hello,

[SQL2008] - version 10.0.2531

The first hit to our SQL2008 Reporting service is always very slow. Its a
VMware and the total server memory is 7GB out of which we have reserved 4GB
for SQLServer and 1.5GB for Reporting services. This is the entry snippet in
rsreportserver config file:
<MemorySafetyMargin>50</MemorySafetyMargin>
<MemoryThreshold>75</MemoryThreshold>
<WorkingSetMaximum>1572864</WorkingSetMaximum>
<WorkingSetMinimum>1048576</WorkingSetMinimum>
<RecycleTime>720</RecycleTime>

Since SQL2008 does not need IIS as prereq to install Reporting services, we
do not have IIS installed. So I cannot play around with the app pools over
there. What else can I check ? please note that otherwise the Reports run
fine, its only that when I invoke the reporting manager console via URL for
first time, that its very slow to load (~6 minutes to load the page
showing10 folders and totalling 20 reports)

Any pointers?

TIA,
AbbA

[Uri Dimant]

Abba
What does the query do? How much rows do you return?

"Abba" <sql_...@aaa.com> wrote in message
news:eOUy4UrY...@TK2MSFTNGP05.phx.gbl...

[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.

"Uri Dimant" <ur...@iscar.co.il> wrote in message
news:e642kXrY...@TK2MSFTNGP05.phx.gbl...

[Dave Ballantyne]

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/

[Bruce L-C [MVP]]

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.aspx

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 seems very excessive, even with a lag
unless it has to do with VMWare.

Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Abba" <sql_...@aaa.com> wrote in message
news:eOUy4UrY...@TK2MSFTNGP05.phx.gbl...

[TheSQLGuru]

Could it also be in part due to having to spin up all the .NET stuff for the
first hit?

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

"Abba" <sql_...@aaa.com> wrote in message
news:eOUy4UrY...@TK2MSFTNGP05.phx.gbl...

[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!

"Dave Ballantyne" <symlink@no5p323mmer> wrote in message
news:ur0LgWuY...@TK2MSFTNGP05.phx.gbl...

[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.

"Bruce L-C [MVP]" <bruce_l...@hotmail.com> wrote in message
news:uoYKEvwY...@TK2MSFTNGP02.phx.gbl...

[Abba]

The dummy reports helped. Thank you Bruce!

"Abba" <sql_...@aaa.com> wrote in message

news:eRF5xk4Y...@TK2MSFTNGP02.phx.gbl...

[Bruce L-C [MVP]]

Good. A bit primitive way of solving it but sometimes that is what works.

--

Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Abba" <sql_...@aaa.com> wrote in message

news:#iYYyhpZ...@TK2MSFTNGP05.phx.gbl...