Setting Reporting Web Server to not automatically shutdown periodically | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Setting Reporting Web Server to not automatically shutdown periodically

I see an this message at the end of the the ReportServer__mm_dd_yy_hh_mm_ss.log file the second oldest log file.
w3wp!webserver!1!11/28/2007-09:17:57:: i INFO: Reporting Web Server stopped
Then in the most recent log file I see this at the beginning:
w3wp!webserver!9!11/28/2007-10:37:19:: i INFO: Reporting Web Server started
I assume this is because I have some how set up reporting to services to automatically shutdown after a period of non-activity.
It seems that everytime the first person tries reporting services when it is stopped. It takes a long time to render the report. Then after it is running it gets rendered much quicker. Once again I’m guessing this happens be cause reporting services needs to start (slow rendering), or is all ready running (fast rendering).
Is ther way to always keep the Reporting Web Server running and not having is shut down periodically Are there drawbacks to doing this?

Does anyone have a solution here? Or suggestions on where else post this question.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |