SSRS - Having to restart services regularly (memory issue?)

Question

Hi

We have a windows server 2012 R2 server with SSRS 2016 installed. The databases are hosted on another server.

The VM has 2 CvPU and 8GB memory and it never has high CPU (not even up to 50%).

This morning reports just stopped working so my colleague restarted the services.

When checking logs you do not get any errors but I can see that memory got up to 7.5GB for the whole server.

Could this be the issue? In theory it has around 0.5GB memory left.

Is there any metrics I can measure or can I add any additional logging?

Thanks

Sam

Answer 1

Hi @Anonymous ,
Restarting the server only temporarily solved the problem of high CPU usage and high memory usage.
There are many reasons for this phenomenon, such as one (several) reports that are poorly developed and cause internal problems in the SSRS engine. Since developers tend to copy/paste reports, problems/errors are propagated in many RDLs.

You could check the following links for troubleshooting:
https://docs.telerik.com/report-server/knowledge-base/troubleshooting-high-cpu-usage-and-memory-consumption
https://deibymarcos.wordpress.com/2014/08/25/microsoft-sql-server-reporting-services-ssrs-consumes-100-of-cpu/

Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.