Thursday, March 29, 2012

Configuration question

I've looked for the answer to this question, but can't find it. How do you
limit the number of report requests that execute at a given time? For
example, if I schedule 100 jobs to execute via a shared schedule at the same
time. How can I tell RS to only run 5 at a time until all 100 have
completed?
ThanksBy default RS will only take on work when it has the resources to do so.
Currently we rely on CPU usage to determine this. We will start working on
at most 2 * number of CPU. If the cpu usage stays low we will continue to
try and do more work. You can limit the total number RS will work on in the
RSReportServer.config file. The MaxQueueThreads tells RS at most how many
threads to use for processing reports. 0 means we will do as described
above, any other number will limit the total work that we can work on at one
time.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"troark" <t.roark@.excite.com.n0sp@.m> wrote in message
news:#R4snWxfEHA.1188@.TK2MSFTNGP11.phx.gbl...
> I've looked for the answer to this question, but can't find it. How do
you
> limit the number of report requests that execute at a given time? For
> example, if I schedule 100 jobs to execute via a shared schedule at the
same
> time. How can I tell RS to only run 5 at a time until all 100 have
> completed?
> Thanks
>|||Great explaination. Thanks!
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OTHD4byfEHA.1428@.TK2MSFTNGP10.phx.gbl...
> By default RS will only take on work when it has the resources to do so.
> Currently we rely on CPU usage to determine this. We will start working
on
> at most 2 * number of CPU. If the cpu usage stays low we will continue to
> try and do more work. You can limit the total number RS will work on in
the
> RSReportServer.config file. The MaxQueueThreads tells RS at most how many
> threads to use for processing reports. 0 means we will do as described
> above, any other number will limit the total work that we can work on at
one
> time.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "troark" <t.roark@.excite.com.n0sp@.m> wrote in message
> news:#R4snWxfEHA.1188@.TK2MSFTNGP11.phx.gbl...
> > I've looked for the answer to this question, but can't find it. How do
> you
> > limit the number of report requests that execute at a given time? For
> > example, if I schedule 100 jobs to execute via a shared schedule at the
> same
> > time. How can I tell RS to only run 5 at a time until all 100 have
> > completed?
> >
> > Thanks
> >
> >
>sqlsql

No comments:

Post a Comment