Reports not running simultaneously.

On our SQL 2005 box it seems that only one report will run at a time. For
example, if I run one of our reports which takes about a minute to complete,
then I try to run another report (even a small one that takes a second to
run) the second report will just stay as a blank screen until the first
report finishes running. Then it will complete.
Is this a setting that can be changed? The reports do no use up all of the
CPU or memory on the server so there are resources available for more reports
to run. I would like to get these reports running simultaneously, especially
the long ones I have scheduled for after hours executions.It sounds like someone set the throttling option to just 1 report per user.
You can change this option - look for this in your rsreportserver.config
file:
(This one is the installation default)
<Add Key="MaxActiveReqForOneUser" Value="20"/>
=-Chris
"Matt M" <MattM@.discussions.microsoft.com> wrote in message
news:6F3ED62A-49B5-456E-A166-ABA523645A22@.microsoft.com...
> On our SQL 2005 box it seems that only one report will run at a time. For
> example, if I run one of our reports which takes about a minute to
> complete,
> then I try to run another report (even a small one that takes a second to
> run) the second report will just stay as a blank screen until the first
> report finishes running. Then it will complete.
> Is this a setting that can be changed? The reports do no use up all of the
> CPU or memory on the server so there are resources available for more
> reports
> to run. I would like to get these reports running simultaneously,
> especially
> the long ones I have scheduled for after hours executions.|||That setting is already set to 20 in the config file. Is there anything else
that would stop a user from running more than one report at a time?
"Chris Conner" wrote:
> It sounds like someone set the throttling option to just 1 report per user.
> You can change this option - look for this in your rsreportserver.config
> file:
> (This one is the installation default)
> <Add Key="MaxActiveReqForOneUser" Value="20"/>
> =-Chris
> "Matt M" <MattM@.discussions.microsoft.com> wrote in message
> news:6F3ED62A-49B5-456E-A166-ABA523645A22@.microsoft.com...
> > On our SQL 2005 box it seems that only one report will run at a time. For
> > example, if I run one of our reports which takes about a minute to
> > complete,
> > then I try to run another report (even a small one that takes a second to
> > run) the second report will just stay as a blank screen until the first
> > report finishes running. Then it will complete.
> >
> > Is this a setting that can be changed? The reports do no use up all of the
> > CPU or memory on the server so there are resources available for more
> > reports
> > to run. I would like to get these reports running simultaneously,
> > especially
> > the long ones I have scheduled for after hours executions.
>
>|||are you using Office Writer by SoftArtisans?
-Tom
Chris Conner wrote:
> It sounds like someone set the throttling option to just 1 report per user.
> You can change this option - look for this in your rsreportserver.config
> file:
> (This one is the installation default)
> <Add Key="MaxActiveReqForOneUser" Value="20"/>
> =-Chris
> "Matt M" <MattM@.discussions.microsoft.com> wrote in message
> news:6F3ED62A-49B5-456E-A166-ABA523645A22@.microsoft.com...
> > On our SQL 2005 box it seems that only one report will run at a time. For
> > example, if I run one of our reports which takes about a minute to
> > complete,
> > then I try to run another report (even a small one that takes a second to
> > run) the second report will just stay as a blank screen until the first
> > report finishes running. Then it will complete.
> >
> > Is this a setting that can be changed? The reports do no use up all of the
> > CPU or memory on the server so there are resources available for more
> > reports
> > to run. I would like to get these reports running simultaneously,
> > especially
> > the long ones I have scheduled for after hours executions.|||No we are not.
"punjab_tom@.hotmail.com" wrote:
> are you using Office Writer by SoftArtisans?
> -Tom
>
>
> Chris Conner wrote:
> > It sounds like someone set the throttling option to just 1 report per user.
> >
> > You can change this option - look for this in your rsreportserver.config
> > file:
> > (This one is the installation default)
> >
> > <Add Key="MaxActiveReqForOneUser" Value="20"/>
> >
> > =-Chris
> >
> > "Matt M" <MattM@.discussions.microsoft.com> wrote in message
> > news:6F3ED62A-49B5-456E-A166-ABA523645A22@.microsoft.com...
> > > On our SQL 2005 box it seems that only one report will run at a time. For
> > > example, if I run one of our reports which takes about a minute to
> > > complete,
> > > then I try to run another report (even a small one that takes a second to
> > > run) the second report will just stay as a blank screen until the first
> > > report finishes running. Then it will complete.
> > >
> > > Is this a setting that can be changed? The reports do no use up all of the
> > > CPU or memory on the server so there are resources available for more
> > > reports
> > > to run. I would like to get these reports running simultaneously,
> > > especially
> > > the long ones I have scheduled for after hours executions.
>