question

Mohan avatar image
Mohan asked

Connectivity issue of Report Manager

When we are connectiving to Report Manager (SSRS 2008 R2 Version) at first time it is taking long time to connect to the server. Once connecting then after in the day it is connecting very fast. How to fix this issue in 2008 R2 Version.
ssrs
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
SirSQL avatar image
SirSQL answered
This is more than likely caused because the app domain is recycling (it does this every 12 hours by default). You can adjust this time by editing the rsreportserver.config file and setting a much higher value or preventing it from happening (which is risky for performance). By default you can find rsreportserver.config under C:\\Program Files\\Microsoft SQL Server\\MSRS10_50.MSSQLSERVER\\Reporting Services\\ReportServer and adjust the value of RecycleTime I highly recommend reading the Microsoft article [Application Domains for Report Server Applications][1] which gives a lot more detail on app domains. [1]: http://msdn.microsoft.com/en-us/library/bb934330(v=sql.105).aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.