Wake Up Reporting Services -- sql server reporting services

sql server reporting services : Wake Up Reporting Services

David
11/9/2006 9:13:02 AM

I noticed the first time I run a report after Reporting Services has
timed-out, it takes around 2 minutes for the report to run. My timeout
setting is currently set to 8 hours. I was thinking that I could add a
subscription to a report to take care of the first run of the report so when
a user runs a report, they wouldn't have to wait 2 minutes. However, this
approach doesn't work, or it doesn't "wake up" reporting services. Has
anyone had any better ideas on how I can "wake up" reporting services?

stcheng NO[at]SPAM online.microsoft.com
11/10/2006 4:07:51 AM

Hello David,

From your description, one of your report will take some minutes to
initialize when the first time user visit it after report server timeout.
And you're looking for a way to automatically access the report at certain
time so as to avoid the first run delay for other interactive users,
correct?

Based on my experience, SQL Reporting service's report can configure
cache/snapshot at server-side to improve responding performance. Does the
"timeout" you mentioned means the timeout of the server-side cache for your
long-run report? If this is the case, I think you need to consider other
means to initalize the report (for first time access) instead of using
subscribe execution.

Since the report cache is mainly targeting web access(URL access) client,
one means I can get so far is create a program which will programmatically
access the report (by sending http request to the report through url), just
like simulate an interative user's access from browser. I'm not sure what's
your prefered programming interface, .net framework has provide some easy
to use class like httpwebrequest,webclient that can send web request to a
web resoruce through url. If you have interests, I can provide some
related resource or code snippet.

Also, you can add the program to task schedule if you want to execute it
constantly.

Please feel free to let me know if you have anything unclear or anything
else we can help.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Bruce L-C [MVP]
11/10/2006 8:05:41 AM

Steven, this is an IIS thing. Here is what to do about it:
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.

You still have the possibility of someone hitting exactly at the time out,
however, if you have any activity at all that won't happen. I have some
scheduled jobs that run every day for other reasons. You could always
schedule a report to run prior to the start of the day.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

stcheng NO[at]SPAM online.microsoft.com
11/13/2006 12:00:00 AM

Thanks for your informative input Bruce!

Hello David,

You can also have a look at the IIS worker process application pool's idle
setting as Bruce mentioned. Please feel free to post here if there is
anything we can help.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

This posting is provided "AS IS" with no warranties, and confers no rights.

David
11/20/2006 8:50:02 AM

Bruce,

How do I schedule a report to run prior to the start of the day? I thought
I did this using subscriptions but I noticed that it doesn't start up all of
the Reporting Services processes. So it still takes around 2 minutes for the
first report to run at the start of the day. By the way, I have read many of
your post in this newsgroup and they have all been very helpful to me!

[quoted text, click to view]

Bruce L-C [MVP]
11/20/2006 11:15:05 AM

If you run a report and email the report that should do it.

Glad the posts have been helpful.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn