SSRS 2019 Report Server URL takes time to load first time of the day

Antony Durai 0 Reputation points
2023-05-16T07:30:53.2466667+00:00

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?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,066 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
Windows for business | Windows Server | User experience | Other
SQL Server | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,516 Reputation points
    2023-05-16T07:34:31.76+00:00

    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.


  2. Anonymous
    2023-05-16T08:19:13.47+00:00

    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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.