question

SamGarth avatar image
0 Votes"
SamGarth asked Joyzhao-MSFT edited

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

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

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @SamGarth ,
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.