all groups > sql server reporting services > november 2006 >
You're in the

sql server reporting services

group:

Reports not running simultaneously.



Reports not running simultaneously. Matt M
11/14/2006 12:33:02 PM
sql server reporting services: 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
Re: Reports not running simultaneously. Chris Conner
11/14/2006 5:19:30 PM
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

[quoted text, click to view]

Re: Reports not running simultaneously. Matt M
11/15/2006 8:52:02 AM
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?

[quoted text, click to view]
Re: Reports not running simultaneously. punjab_tom NO[at]SPAM hotmail.com
11/15/2006 10:49:01 AM
are you using Office Writer by SoftArtisans?

-Tom




[quoted text, click to view]
Re: Reports not running simultaneously. Matt M
11/15/2006 10:59:01 AM
No we are not.

[quoted text, click to view]
AddThis Social Bookmark Button