| Groups | Blog | Home |
sql server reporting services : Does RS process sleep?
But both servers RS processes sleep if no users access to them over an hour. Once it sleeps, the user has to wait 20 seconds to start responding the request. Is this normal? Is there anyway to prevent this waiting time? Please help!!
What I do is have a very simple report that auto-refreshes every 5 minutes.
That keeps it alive. There is also an IIS configuration that can be set but I haven't used it and I don't remember it off the top of my head. The auto-refresh is pretty easy hack though. Instead of 5 minutes you could set it longer than than (30 minutes?). -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Aki Nomura" <anomura@jtb.com> wrote in message news:%23TPmKK1%23FHA.3104@TK2MSFTNGP15.phx.gbl... >I tried both SQL2000 & SQL2005. > But both servers RS processes sleep if no users access to them over an > hour. > Once it sleeps, the user has to wait 20 seconds to start responding the > request. > Is this normal? Is there anyway to prevent this waiting time? > Please help!! > > >
Auto-refreshes means scheduling report?
Actually I tried an every 3 minutes schedule report. But it didn't work for my case. Anyway, I will try the IIS configuration. Thanks. [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:OXDxAt6%23FHA.328@TK2MSFTNGP14.phx.gbl... > What I do is have a very simple report that auto-refreshes every 5 > minutes. That keeps it alive. There is also an IIS configuration that can > be set but I haven't used it and I don't remember it off the top of my > head. The auto-refresh is pretty easy hack though. > > Instead of 5 minutes you could set it longer than than (30 minutes?). > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > "Aki Nomura" <anomura@jtb.com> wrote in message > news:%23TPmKK1%23FHA.3104@TK2MSFTNGP15.phx.gbl... >>I tried both SQL2000 & SQL2005. >> But both servers RS processes sleep if no users access to them over an >> hour. >> Once it sleeps, the user has to wait 20 seconds to start responding the >> request. >> Is this normal? Is there anyway to prevent this waiting time? >> Please help!! >> >> >> > >
Layout, report tab, autorefreshes checkbox. Once you have a report that
autorefreshes then open it and leave it up. This has worked for me both with RS 2000 and RS 2005. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Aki Nomura" <anomura@jtb.com> wrote in message news:OzI$fDD$FHA.504@TK2MSFTNGP09.phx.gbl... > Auto-refreshes means scheduling report? > Actually I tried an every 3 minutes schedule report. > But it didn't work for my case. > Anyway, I will try the IIS configuration. > Thanks. > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > news:OXDxAt6%23FHA.328@TK2MSFTNGP14.phx.gbl... >> What I do is have a very simple report that auto-refreshes every 5 >> minutes. That keeps it alive. There is also an IIS configuration that can >> be set but I haven't used it and I don't remember it off the top of my >> head. The auto-refresh is pretty easy hack though. >> >> Instead of 5 minutes you could set it longer than than (30 minutes?). >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> >> "Aki Nomura" <anomura@jtb.com> wrote in message >> news:%23TPmKK1%23FHA.3104@TK2MSFTNGP15.phx.gbl... >>>I tried both SQL2000 & SQL2005. >>> But both servers RS processes sleep if no users access to them over an >>> hour. >>> Once it sleeps, the user has to wait 20 seconds to start responding the >>> request. >>> Is this normal? Is there anyway to prevent this waiting time? >>> Please help!! >>> >>> >>> >> >> > >
Yes, it works.
Thanks again. [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:egpp%23KE$FHA.2036@TK2MSFTNGP14.phx.gbl... > Layout, report tab, autorefreshes checkbox. Once you have a report that > autorefreshes then open it and leave it up. This has worked for me both > with RS 2000 and RS 2005. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > "Aki Nomura" <anomura@jtb.com> wrote in message > news:OzI$fDD$FHA.504@TK2MSFTNGP09.phx.gbl... >> Auto-refreshes means scheduling report? >> Actually I tried an every 3 minutes schedule report. >> But it didn't work for my case. >> Anyway, I will try the IIS configuration. >> Thanks. >> >> >> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message >> news:OXDxAt6%23FHA.328@TK2MSFTNGP14.phx.gbl... >>> What I do is have a very simple report that auto-refreshes every 5 >>> minutes. That keeps it alive. There is also an IIS configuration that >>> can be set but I haven't used it and I don't remember it off the top of >>> my head. The auto-refresh is pretty easy hack though. >>> >>> Instead of 5 minutes you could set it longer than than (30 minutes?). >>> >>> >>> -- >>> Bruce Loehle-Conger >>> MVP SQL Server Reporting Services >>> >>> >>> "Aki Nomura" <anomura@jtb.com> wrote in message >>> news:%23TPmKK1%23FHA.3104@TK2MSFTNGP15.phx.gbl... >>>>I tried both SQL2000 & SQL2005. >>>> But both servers RS processes sleep if no users access to them over an >>>> hour. >>>> Once it sleeps, the user has to wait 20 seconds to start responding the >>>> request. >>>> Is this normal? Is there anyway to prevent this waiting time? >>>> Please help!! >>>> >>>> >>>> >>> >>> >> >> > >
That is called Application Pool in IIS. 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. [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:OXDxAt6%23FHA.328@TK2MSFTNGP14.phx.gbl... > What I do is have a very simple report that auto-refreshes every 5 > minutes. That keeps it alive. There is also an IIS configuration that can > be set but I haven't used it and I don't remember it off the top of my > head. The auto-refresh is pretty easy hack though. > > Instead of 5 minutes you could set it longer than than (30 minutes?). > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > "Aki Nomura" <anomura@jtb.com> wrote in message > news:%23TPmKK1%23FHA.3104@TK2MSFTNGP15.phx.gbl... >>I tried both SQL2000 & SQL2005. >> But both servers RS processes sleep if no users access to them over an >> hour. >> Once it sleeps, the user has to wait 20 seconds to start responding the >> request. >> Is this normal? Is there anyway to prevent this waiting time? >> Please help!! >> >> >> > >
Wow, This is what I was looking for.
Thank you. [quoted text, click to view] "Norman Yuan" <NotReal@NotReal.not> wrote in message news:uSWtdkQ$FHA.532@TK2MSFTNGP15.phx.gbl... > That is called Application Pool in IIS. 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 L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > news:OXDxAt6%23FHA.328@TK2MSFTNGP14.phx.gbl... >> What I do is have a very simple report that auto-refreshes every 5 >> minutes. That keeps it alive. There is also an IIS configuration that can >> be set but I haven't used it and I don't remember it off the top of my >> head. The auto-refresh is pretty easy hack though. >> >> Instead of 5 minutes you could set it longer than than (30 minutes?). >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> >> "Aki Nomura" <anomura@jtb.com> wrote in message >> news:%23TPmKK1%23FHA.3104@TK2MSFTNGP15.phx.gbl... >>>I tried both SQL2000 & SQL2005. >>> But both servers RS processes sleep if no users access to them over an >>> hour. >>> Once it sleeps, the user has to wait 20 seconds to start responding the >>> request. >>> Is this normal? Is there anyway to prevent this waiting time? >>> Please help!! >>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |