SSRS base on web server and the default a web server shut down after a period of idle and have to restart on the next call; that's how web server works.
Create a job that frequently calls SSRS to avoid it.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi Team,
we have migrated our SSRS reports from 2016 to 2019.
version : Microsoft SQL Server Reporting Services Version 15.0.1102.1047
Everyday when I try to browse Web Server URL (Report Server URL) for the first time of the day it takes 1 minute and 40 Seconds and subsequent requests it just takes 2-3 seconds.
This 1 minute and 40 Minute slowness we are facing once or twice in a day.
we have Checked executionlogstorage table and could not find the reason for it.
we have only less number of reports and have enough hardware resources.
Please let me know why its happening?
SSRS base on web server and the default a web server shut down after a period of idle and have to restart on the next call; that's how web server works.
Create a job that frequently calls SSRS to avoid it.
Hi @Antony Durai
As Olaf said, it's normal for SSRS to take more time to load it the first time you visit it after a period of inactivity.
You can check out these discussions to help you figure it out: https://stackoverflow.com/questions/11207049/sql-reporting-services-first-call-is-very-slow.
Best regards,
Aniya