SSRS Reporting Windows Service Manually Restart

Antony Durai 0 Reputation points
2023-06-02T04:57:14.6433333+00:00

Hi Team,

We are having a SSRS Reports which runs slow in every first day of the Transaction.

It Takes approx. 90 Seconds for the first Request and subsequent request it took only 1-2 Seconds.

I understand this is because of the SSRS nature and its APP domain gets recycled every 720 Minutes.

As I Checked in the Log Files this Recycle is happening twice a day (2.00 AM & 2.00PM)

So I am planning to write a PowerShell Script to start SSRS Service at 6.00 AM Daily. So that users will not see a first time slowness.

My Question here is restarting SSRS from PowerShell on a Daily basis is good Choice or Cause any issue.

Need your Clarification here

Thanks.

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,603 questions
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.
2,870 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,314 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 43,166 Reputation points
    2023-06-02T05:54:55.8133333+00:00

    which runs slow in every first day of the Transaction.

    SSRS is mainly a web server and it's by design that a web server goes into sleep after a period of idle. The first access to SSRS starts it up and that can take some time.

    My Question here is restarting SSRS from PowerShell on a Daily basis is good Choice

    No, it won't change the behaviour, the first report call takes some time.

    And taht the soultion, the "first call", so use PowerShell for a first report request instead, it's a simple Html client request.


  2. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2023-06-02T08:21:15.3266667+00:00

    Hi @Antony Durai

    I don't know PowerShell very well. But from my searches, using a PowerShell script does provide an acceptable workaround.

    For more information you can check this link: https://stackoverflow.com/questions/11207049/sql-reporting-services-first-call-is-very-slow.

    Best regards,

    Aniya

    0 comments No comments