This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 85%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
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.
Thanks Olaf Helper for the comment. I have separate SSRS instances in my Local system and VMware Server.
I could see difference in local system first load of the day takes 20 seconds and
in server it takes 1 minute 40 seconds. why is it like that any idea pls
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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