search

AngelaIp / add-ssrs-reports-to-vault

How to get files from the SSRS Report Server
Microsoft Public License
3 stars 2 forks source link

First report is always generated very slowly #3

Open AngelaIp opened 6 years ago

AngelaIp commented 6 years ago

When starting a report for the first time, the login to the Report Server takes quite long. It takes about 15 seconds to generate a report. The Report Server reacts faster in the following reports (2 seconds to get the report). This behavior also occurs during regular access through the Rsgateway.aspx. Does anyone know the reason for this behaviour or how to accelerate the login procedure?

AngelaIp commented 1 year ago

Turned out that this issue is not a bug, but normal behavior of SSRS. See: https://stackoverflow.com/questions/11207049/sql-reporting-services-first-call-is-very-slow

Quote: The issue is caused by the way how SSRS works and SSRS regularly restarts application domain after a specific time period. After the application domain is restarted, then upon first request to the SSRS it needs to load all the settings and it takes quite a long time.

Workaround is possible via PowerShell script: https://pawlowski.cz/2011/07/31/solving-issue-long-starting-report-ssrs-2008/