Only one report at a time?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 26 Jun 2008 14:11 GMT

Hello!

When I connect to my report-server, It always processes the reports in
serial, I have confirmed this by tracing using Sql Profiler.

(I connect using two/three different IE and run a large report)

So how do I fix this - the server seems to have more than enough of CPU/RAM
but we are not able to use it.

-Do I have to install multiple RS-instances on the machine?

David

Reply to this Message

David - 27 Jun 2008 08:15 GMT

Seemingly this has nothing to do w RS.

If I try connect from different computers, processing is parallel and agile!

Hmm this could be the internet-proxy that thinks Im doing DoS attacks.

Anyway - case closed. Hope I didn't look too stupid.

David

> Hello!
>
[quoted text clipped - 9 lines]
>
> David

Reply to this Message

Bruce L-C [MVP] - 27 Jun 2008 16:21 GMT

Thanks for telling us what you found. I think what could be happening is
that this is on purpose so one person doesn't dominate the server but allows
resources to be available for other people.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Seemingly this has nothing to do w RS.
>
[quoted text clipped - 20 lines]
>>
>> David

Reply to this Message