question

MitchMcBride-9130 avatar image
0 Votes"
MitchMcBride-9130 asked MitchMcBride-9130 commented

SSRS Web Service Unresponsive Under Load

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
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 MitchMcBride-9130 commented

Hi @MitchMcBride-9130
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.

· 2
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.

You can also use performance counter to monitor the server.

0 Votes 0 ·

Hi Joy,

Thanks for the reply. I have been monitoring HTTP Service Request Queue -> CurrentQueueSize and .NET CLR LockedAndThreads -> Current Queue Length during times of unavailability, but both are 0 or close to it. Are there any specific counters that you recommend?

Thanks,
Mitch

0 Votes 0 ·