RS2005 Performance Test Tool

Dear Anyone,

Is there a tool that we can use to simulate the performance of Reporting services?

Our team will be implementing performance tests over the reports we created over the corporate network. in reality, we expect about not more than 500 concurrent users but it could possibly go higher. We would need to do stress testing.

I was wondering if there is a performance tool out there that can simulate numbers of users accessing reports from our server? Any recommendations on how we can test this?

Thanks,

Joseph

Hi,

In my department, we use Opensta.

http://www.opensta.org/

Regards

Ayzan

sql

RS Services Graphical Extensions? (Dashboard Gauges)

hello all,
I am trying to use RS in order to develop a dashboard like application that
would start at KPI (Key Performance indicators) level and drill through to
more detailed levels of table/matrix reports. all the drill through and
drill down with parameter passing is all done. I can not seem to find any
third party application or custom code that would extend the built-in
graphical library ( pie, horizontal bar, scattered, etc charts) to have
Guages and instrumentation like graphs. Is there anything like that
available on the market?
Thank You
Tony A.
aaltobelli007{at}yahoo.comHi....
Dundas (http://www.dundas.com/) has some graph tools that have gauges.
With regards,
Arnar Freyr
"Tony A. via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:cc164c93e64842838b70e62156e8cf14@.SQLMonster.com...
> hello all,
> I am trying to use RS in order to develop a dashboard like application
> that
> would start at KPI (Key Performance indicators) level and drill through to
> more detailed levels of table/matrix reports. all the drill through and
> drill down with parameter passing is all done. I can not seem to find any
> third party application or custom code that would extend the built-in
> graphical library ( pie, horizontal bar, scattered, etc charts) to have
> Guages and instrumentation like graphs. Is there anything like that
> available on the market?
> Thank You
> Tony A.
> aaltobelli007{at}yahoo.com|||I took a look at them. they are good product if you intend to write a dot
Net application using them, howerver, I wanted to know if there is a guage
control that can be (dragged) from too TOOLBOX >>CHARTs From the Report
Designer in RS?
Is there anything like that ?
Thanks
Tony
--
Message posted via http://www.sqlmonster.com|||This capability is not supported in SQL 2000 RS but will be possible in SQL
2005 RS. Several 3rd parties have signed up to do extensions.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony A. via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:3abe33ccba65409b9e435158465397a8@.SQLMonster.com...
>I took a look at them. they are good product if you intend to write a dot
> Net application using them, howerver, I wanted to know if there is a guage
> control that can be (dragged) from too TOOLBOX >>CHARTs From the Report
> Designer in RS?
> Is there anything like that ?
> Thanks
> Tony
> --
> Message posted via http://www.sqlmonster.com|||Do you have a list of these parties, i would like to contact them. I would
like to develop a solution/service based on that! I know of Dundas
Software, Are there others? appreciate your cooperation.
--
Message posted via http://www.sqlmonster.com|||You could use Xcelsius (from Infommersion) to handle the graphical interface
and then use a web service retrieve the data from your RS reports into your
Xcelsius dashboards. That is the solution I am using and I'm very happy
with the results. I leverage the cached, hourly reports in RS as a source to
my interactive dashboards in Xcelsius. I don't need to add any .NET coding
to get this done and I get to use existing RS reports as my data source.
It's a very nice solution to a low-maintenance, data-intense dashboard.
regards,
Brad Peterman
brad.peterman@.libertysite.com
"Antony Altobelli via SQLMonster.com" wrote:
> Do you have a list of these parties, i would like to contact them. I would
> like to develop a solution/service based on that! I know of Dundas
> Software, Are there others? appreciate your cooperation.
> --
> Message posted via http://www.sqlmonster.com
>

RS Matrix Rendering Performance - help required

Dear All,
I am currently trialling MS Reporting Services and have so far been highly
impressed with the flexibility and functionality of the software. It
certainly out classes all of the other reporting solutions I have seen. That
is with one exception! I have so far designed several matrix based reports,
all of which render to the screen in <5 seconds and look superb. The
problems start to occur when I try and render the reports to PDF.
As an example, I have one matrix based report with 4 column header fields
and 8 row header fields producing a report of approx 150 pages. When I view
the report as HTML it takes approx 5s to run. If I then attempt to render it
as a PDF, the server CPU usage hits 100% (aspnet_wp.exe) and after several
hours is still attempting to render the report. If take exactly the same
report and remove 4 of the row header fields (doesn't shorten the report as
fields I remove are uniquely defined by a reference which remains) the report
now renders as a PDF in approx 20s !!?
I think this a superb product but desperately require a solution to this
problem. Most of our reporting is high level management reporting, to which
matrix based reports naturally lend themselves. Being restriced to 3-4 row
header fields is quite unworkable for our reporting needs, but I'd be loathed
to have to resort to another solution (e.g. crystal)
Any help would be much appreciated.Just to follow up on the previous posting, we are running MS Reporting
Services SP1 on a 2.4Ghz Single Processor machine with 1Gb Ram
"AndyC" wrote:
> Dear All,
> I am currently trialling MS Reporting Services and have so far been highly
> impressed with the flexibility and functionality of the software. It
> certainly out classes all of the other reporting solutions I have seen. That
> is with one exception! I have so far designed several matrix based reports,
> all of which render to the screen in <5 seconds and look superb. The
> problems start to occur when I try and render the reports to PDF.
> As an example, I have one matrix based report with 4 column header fields
> and 8 row header fields producing a report of approx 150 pages. When I view
> the report as HTML it takes approx 5s to run. If I then attempt to render it
> as a PDF, the server CPU usage hits 100% (aspnet_wp.exe) and after several
> hours is still attempting to render the report. If take exactly the same
> report and remove 4 of the row header fields (doesn't shorten the report as
> fields I remove are uniquely defined by a reference which remains) the report
> now renders as a PDF in approx 20s !!?
> I think this a superb product but desperately require a solution to this
> problem. Most of our reporting is high level management reporting, to which
> matrix based reports naturally lend themselves. Being restriced to 3-4 row
> header fields is quite unworkable for our reporting needs, but I'd be loathed
> to have to resort to another solution (e.g. crystal)
> Any help would be much appreciated.
>

RS Execution Logs sample project

Hi,

I was going through the link http://msdn2.microsoft.com/en-us/library/aa964131.aspx for "Monitoring Report Execution Performance with Execution Logs". There is a link (http://datainspirations.com/uploads/rsexecutionlogging.zip) proviced for downloading sample project. It seems that the page no more exists.

Can any one please let me know from where can i download the sample project?

TIA

You can find correct links here:

http://datainspirations.com/Publications.html

|||Even this link doesn't work.If you know the llink,please send me.|||It works for me.

RS Execution Logs sample project

Hi,

I was going through the link http://msdn2.microsoft.com/en-us/library/aa964131.aspx for "Monitoring Report Execution Performance with Execution Logs". There is a link (http://datainspirations.com/uploads/rsexecutionlogging.zip) proviced for downloading sample project. It seems that the page no more exists.

Can any one please let me know from where can i download the sample project?

TIA

You can find correct links here:

http://datainspirations.com/Publications.html

|||Even this link doesn't work.If you know the llink,please send me.|||It works for me.

RS can't handle the load -- How can I lower concurrent requests?

I'm running a report schedule with 400 reports on it. RS is trying to run the
reports 8 at a time (according to the Performance Counter), and can't handle
the load. It writes out four or so, then hangs for an hour, occasionally
writing a successful report or failing a request with a "rendering error" or
a "write failure".
Last month we had a much smaller volume of data. This month it's not working
properly.
How do I set the number of concurrent requests that RS tries to run?You can set the MaxQueueThreads element in the RSReportServer.config file.
0 is the default and means RS will attempt to figure out the amount to load.
Any other number is the max number that RS will process at one time.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"AJ Cohen" <AJCohen@.nospam.nospam> wrote in message
news:95AFC3C0-A3D9-44B5-BEF3-C600E9864DA3@.microsoft.com...
> I'm running a report schedule with 400 reports on it. RS is trying to run
> the
> reports 8 at a time (according to the Performance Counter), and can't
> handle
> the load. It writes out four or so, then hangs for an hour, occasionally
> writing a successful report or failing a request with a "rendering error"
> or
> a "write failure".
> Last month we had a much smaller volume of data. This month it's not
> working
> properly.
> How do I set the number of concurrent requests that RS tries to run?
>