Saturday, February 25, 2012

RS can't handle the load -- How can I lower concurrent requests?

I'm running a report schedule with 400 reports on it. RS is trying to run the
reports 8 at a time (according to the Performance Counter), and can't handle
the load. It writes out four or so, then hangs for an hour, occasionally
writing a successful report or failing a request with a "rendering error" or
a "write failure".
Last month we had a much smaller volume of data. This month it's not working
properly.
How do I set the number of concurrent requests that RS tries to run?You can set the MaxQueueThreads element in the RSReportServer.config file.
0 is the default and means RS will attempt to figure out the amount to load.
Any other number is the max number that RS will process at one time.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"AJ Cohen" <AJCohen@.nospam.nospam> wrote in message
news:95AFC3C0-A3D9-44B5-BEF3-C600E9864DA3@.microsoft.com...
> I'm running a report schedule with 400 reports on it. RS is trying to run
> the
> reports 8 at a time (according to the Performance Counter), and can't
> handle
> the load. It writes out four or so, then hangs for an hour, occasionally
> writing a successful report or failing a request with a "rendering error"
> or
> a "write failure".
> Last month we had a much smaller volume of data. This month it's not
> working
> properly.
> How do I set the number of concurrent requests that RS tries to run?
>

No comments:

Post a Comment