SSRS Web Service Unresponsive Under Load

Mitch McBride 1 Reputation point
2021-04-29T20:13:48.967+00:00

Hello,

We deliver Reporting Services reports to our customers via a web application with an embedded ReportViewer control. We have 3 Reporting Services servers load-balanced to provider high availability and increased capacity. During peak usage, the SSRS APIs (http://hostname/reportserver) become periodically unresponsive for tens of seconds, causing a poor user experience. The hosts that run the unresponsive services are fairly underutilized during this time (< 30% CPU and no memory pressure). Each server has 16 CPUs and 1.5 TB of RAM. It feels as if the system is queueing requests, but there is nothing in the logs that says it's doing so.

I have tried changing various rsreportserver.config configuration settings in an attempt to increase parallelism, but haven't found anything that resolves the problem. Here are my non-default config setting:

<Add Key="MaxActiveReqForOneUser" Value="100"/>
<Add Key="MaxActiveReqForAnonymous" Value="500"/>

    <RecycleTime>10080</RecycleTime>
    <WorkingSetMinimum>20000000</WorkingSetMinimum>

Is there a configuration setting that I can change to allow the service to handle more reports or connections concurrently?

Thanks,
Mitch

SQL Server ReportServer database Version: 14.0.3208.1
Reporting Services Version: 14.0.600.1274

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,102 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,361 Reputation points Microsoft Employee
    2021-04-30T08:55:29.403+00:00

    Hi @Mitch McBride
    In terms of performance, we need to obtain SQL data for observation. I suggest you choose phone support (this may require some payment), but usually this kind of issue will be resolved. The following are two ways to obtain support:
    https://support.microsoft.com/en-US/help/4051701/global-customer-service-phone-numbers
    https://support.microsoft.com/en-us/supportforbusiness/productselection​
    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.