question

AnthonyBercasio-6772 avatar image
0 Votes"
AnthonyBercasio-6772 asked Joyzhao-MSFT commented

SSRS 2017 take so long to load after service restart

After the Recycle Time or if we have to restart the SSRS service for changes in the configuration manager, it will take 15-30mins for the ReportServer or any reports to be accessible.

Has anyone had this issue before

sql-server-reporting-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AnthonyBercasio-6772 ,
Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Regards,
Joy

0 Votes 0 ·

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @AnthonyBercasio-6772 ,
Try to use the following statement to see which stage takes the longest time :

 Use ReportServer
 select * from ExecutionLog3 order by TimeStart DESC

You can use the report execution log to find out how often a report is requested, what output formats are used the most, and how many milliseconds of processing time is spent on each processing phase. The log contains information on the length of time spent executing a report's dataset query and the time spent processing the data. If you are a report server administrator, you can review the log information and identify long running tasks and make suggestions to the report authors on the areas of the report (dataset or processing) they may be able to improve.
For more information, you can view: Report Server ExecutionLog and the ExecutionLog3 View.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.