MOTIO and performing load testing in COGNOS BI

[7zark7]

Hi All,

We currently have issues in regards to performance and believe its due to concurrency ( users bashing the same report at the same time ). there are also issues in regards
to report design etc as well, but I wont go into that. In the end I wanted to see if there is currently a tool on the market that can be used to perform load testing, specifically in relation to COGNOS BI. One test that will work is to continuously refresh a report every 10-15 seconds for a duration of 30minutes x 20 users, maybe there is some out of the box / third party tool that can emulate this?

Based on users experience can anyone tell me what the best tool there is currently on the market to load test COGNOS BI?

We have been engaged by an IBM business partner to help in this regard with a third party tool called MOTIO. Has anyone used this tool and if so how
well does it load test? I am skeptical partly based on previous dealings with this partner and also since I donot understand MOTIO as a product and how it would emulate
concurrency.

Looking forward to your responses.

Cheers

Zark

[sdf]

Try to search for HP LoadRunner. You can download the trial version and try to test it for yourself.
It's quite easy to use. You record a script (running a report in cognos), then create a scenario into the manner how users run report (one by one at a given time, simultaneously.. etc), then see the stats.

[Andrew Weiss]

Zark,

Our Performance Bundle in MetaManager provides a load generation module for continuously running concurrent reports.  It lets you pick a selection of reports, users and configure how much load you want.  Then it randomizes this to simulate what an actual person might do.  There is some more information on the module located here: http://www.bspsoftware.com/products/metamanager/Perform/ and you can also download a trial to give it a try for yourself.

Alternatively if you just need a cheap and dirty solution you can use JMeter, which is free.  There is some information on IBM's site about using JMeter for load testing here: http://www.ibm.com/developerworks/data/library/cognos/performance/load_testing/page584.html

Let me know if you interested in our performance solution, I can set you up with a demonstration.

Thanks,
-Andy