Hello,
I have SSRS installed on an r4.2XL (AWS) node (64 GB x 8 CPU). We have developed a Report Generation service which runs queued report requests from our main platform application. A single request can contain upwards of 10,000 reports. This service is set to run 2 threads with each serving 12 rendering requests.
This all has been working fine and dandy.
Until now.
With a new product several new reports have additional complexity and now, when both threads are running, I am getting 'System.OutOfMemoryException' errors. If I run the request single threaded, it completes. While running both threads memory usage on the node never goes above 15 GB (of a 64 GB total) I do not have the WorkingSetMaximum or WorkingSetMinimum values set so all of the system memory is available to SSRS. SSRS and our service are the only applications running on the server.
I have tried giving huge (relatively) values to WorkingSetMaximum and have adjusted MemorySafetyMargin and MemoryThreshold values to give more space for high memory pressure scenarios, but still receive the memory error.
Suggestions?
TIA
Please specify your main memory of your server, Out of that how much m/y was given to SSRS. Please check the Report config file and look for
Working set Maximim
Memory Safety Margin
Memory Threshold
Please increase working set to maximum value and try to increase the RAM of your server, then assign the more m/y to SSRS to consume.
Please edit the report config file for these settings and Take a back up first.