With one of our clients, we were facing this issue of reports loading really slow. Even the simple document reports were taking 2-3minutes to display data. So finally the solution came out that we need to increase the recycle time of the SSRS.
That's how to do this:
Navigate to "C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer" (depending on the SSRS version).
Look for file RSReportServer.config and open it.
Now find the tag "RecycleTime" from the default "720" to "1440". You can try increasing the value further depending on the performance.
Hope this helps. :)
That's how to do this:
Navigate to "C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer" (depending on the SSRS version).
Look for file RSReportServer.config and open it.
Now find the tag "RecycleTime" from the default "720" to "1440". You can try increasing the value further depending on the performance.
Hope this helps. :)
No comments:
Post a Comment