Performance Testing of TM1 software

Post Reply
saras
Posts: 11
Joined: Wed Aug 11, 2010 3:25 pm
OLAP Product: IBM Cognos TM1
Version: 9.5
Excel Version: 2007

Performance Testing of TM1 software

Post by saras »

Hi
Which is the best software Testing tool to do a performance testing on TM1? Any thoughts are highly appreciated.
Thanks
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Performance Testing of TM1 software

Post by rkaif »

TM1 includes some tools to monitor the performance. You can get the details about TM1 Performance Monitor here:

http://publib.boulder.ibm.com/infocente ... sp?lang=en

You can also use Microsoft Windows Performance Monitor to view TM1 Performance counter:

http://publib.boulder.ibm.com/infocente ... icros.html
Cheers!
Rizwan Kaif
saras
Posts: 11
Joined: Wed Aug 11, 2010 3:25 pm
OLAP Product: IBM Cognos TM1
Version: 9.5
Excel Version: 2007

Re: Performance Testing of TM1 software

Post by saras »

rkaif wrote:TM1 includes some tools to monitor the performance. You can get the details about TM1 Performance Monitor here:

http://publib.boulder.ibm.com/infocente ... sp?lang=en

You can also use Microsoft Windows Performance Monitor to view TM1 Performance counter:

http://publib.boulder.ibm.com/infocente ... icros.html
Thanks for replying. I am looking for some third party tool which would stress or put a load on TM1 system and record the behaviour of the TM1 system (9.5.1 version). We are thinking of Loadrunner as such one tool to evaluate the performance. Do we have any other such tools? - Thanks SARAS
David Usherwood
Site Admin
Posts: 1454
Joined: Wed May 28, 2008 9:09 am

Re: Performance Testing of TM1 software

Post by David Usherwood »

The development team at IBM use Loadrunner to test performance. I've heard it's big $$$.
We wrote an Excel macro to test performance of various 9.x versions by reading or writing data at slightly randomised times. I wouldn't say it would scale that well as you needed a set of actual client sessions in which to run the multiple copies. Bit of a Blue Peter job, but useful as it told us that the vaunted performance gains of 9.1 over 9.0 were (at the time) - shall I say - somewhat over vaunted :)
Post Reply