SSRS Reporting Windows Service Manually Restart

Question

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.

Answer 1

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.

Answer 2

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