Re: stress testing

And when you're doing stress testing, make sure you load your system for quite long time.
Stress testing shouldn't only verify system performance, but it should also test system's reliability.

One of my clients had a problem with Oracle Apps, where they did a stress test for just one hour and concluded that the performance was acceptable. But one of the components in Apps (forms server) started just hanging after 5-6 hours of usage in their system, so if they had done an automated stress test over a weekend or even more, they'd have found it.

Also, any kind of testing should simulate "real life", if possible - otherwise you'll get results which might not match with future production usage all. That means, the amounts of data should be similar, if you can use a copy of "real system" for testing it'd be the best, also note that there are probably different usage patterns in your future system (such as month/year ending, campaign periods in retail businesses etc) so your system has to cope with all of them.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, January 02, 2004 9:29 PM

> Henry,
>
> Sar is a better tool than vmstat/iostat as it collects a broad range of
> information. Specifically, sar -q should show up CPU queueing and
swapping,
> and sar -v will show up file/process table overflow issues that may occur
> during stress testing. IMHO, sar is quite underutilized.... ( had a paper
on
> this last IOUG, but couldn't go and present it :(
>
> John Kanagaraj
> DB Soft Inc
> Phone: 408-970-7002 (W)
>
> Grace - Getting something we do NOT deserve
> Mercy - NOT getting something we DO deserve
> Click on 'http://www.needhim.org' for Grace and Mercy that is freely
> available!
>
> ** The opinions and facts contained in this message are entirely mine and
do
> not reflect those of my employer or customers **
>
> >-----Original Message-----
> >From: Poras, Henry R. [mailto:Henry_Poras_at_dfci.harvard.edu]
> >Sent: Friday, January 02, 2004 10:54 AM
> >To: Multiple recipients of list ORACLE-L
> >Subject: stress testing
> >
> >
> >We are planning on running some stress tests on a
> >PeopleSoft/Oracle/Solaris
> >system starting next week (using LoadRunner). I have never
> >gone through a
> >formalized stress test before (most of my stress is brought
> >about informally).
> >So far I am planning to gather statspack information, and
> >periodically get
> >vmstat from the OS. Is there anything else that I should
> >collect? Thanks for the
> >help.
> >
> >Henry
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author: Poras, Henry R.
> > INET: Henry_Poras_at_dfci.harvard.edu
> >
> >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >San Diego, California -- Mailing list and web hosting services
> >---------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: John Kanagaraj
> INET: john.kanagaraj_at_hds.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).