Report Service Seems to Go to Sleep

Hi,
I have a report server that is working almost fine and dandy. The only
little snafu seems to be if no one hits the server for "a while" the
report server seems to "go to sleep". Bringing up a report after it
has done this can take a little time, but any subsequent reports come
up nice and fast as they should. I also notice on the first hit in a
long time that the following message in the event log shows up:
"The ReportServer service has been activated."
Occassionally I will even see a timeout error occur the first time I
try to go to a report. But if I try it a second time it comes up nice
and quick. Is there a way to tune report server so that it doesn't do
this? Has anyone else run into this?
Thanks,
BillThis is a property in ASP.Net and your website. You can change worker
process recycling on the Application Pool of IIS6.0 to be just about as
long as you like.
--
| From: "zinck74" <bkelly3@.gmail.com>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: Report Service Seems to Go to Sleep
| Date: 5 Jul 2005 17:13:56 -0700
| Organization: http://groups.google.com
| Lines: 18
| Message-ID: <1120608836.572936.22790@.g43g2000cwa.googlegroups.com>
| NNTP-Posting-Host: 131.107.0.103
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1120608842 16730 127.0.0.1 (6 Jul 2005
00:14:02 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Wed, 6 Jul 2005 00:14:02 +0000 (UTC)
| User-Agent: G2/0.2
| Complaints-To: groups-abuse@.google.com
| Injection-Info: g43g2000cwa.googlegroups.com; posting-host=131.107.0.103;
| posting-account=H4pdeQ0AAACXytwviGUvL2hDckWajAKB
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g4
3g2000cwa.googlegroups.com!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:47443
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
| I have a report server that is working almost fine and dandy. The only
| little snafu seems to be if no one hits the server for "a while" the
| report server seems to "go to sleep". Bringing up a report after it
| has done this can take a little time, but any subsequent reports come
| up nice and fast as they should. I also notice on the first hit in a
| long time that the following message in the event log shows up:
|
| "The ReportServer service has been activated."
|
| Occassionally I will even see a timeout error occur the first time I
| try to go to a report. But if I try it a second time it comes up nice
| and quick. Is there a way to tune report server so that it doesn't do
| this? Has anyone else run into this?
|
| Thanks,
| Bill
|
|