Only one report at a time?
in [Reports]
|
From: David on 26 Jun 2008 09:11 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
From: David on 27 Jun 2008 03:15 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 "David" <david_sundstrom_sandegard.nospam(a)hotmail.com> wrote in message news:CA20C11F-C231-449E-9DBB-ECD52CF168AC(a)microsoft.com... > 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
From: Bruce L-C [MVP] on 27 Jun 2008 11:21 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. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "David" <david_sundstrom_sandegard.nospam(a)hotmail.com> wrote in message news:23DACE1D-DB6E-441B-98C2-B05F510F00BF(a)microsoft.com... > 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 > > "David" <david_sundstrom_sandegard.nospam(a)hotmail.com> wrote in message > news:CA20C11F-C231-449E-9DBB-ECD52CF168AC(a)microsoft.com... >> 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 >
|
Pages: 1 Prev: Several spaces between texts in RS 2000 Next: Drilldown report |