Performance Monitoring(generic)

[Prashant Zanwar]

I work with Transco, UK.
Client has installed few new system in their setup, they are L-Class, And L-Class 2000.
Client will be doing a load testing on these systems. These systems are basically installed for oracle 9i database. System information is as below:

CPU_BINARY : PA-RISC 2.0
PROCESSOR TYPE : PA8600
CPU-SPEED : 750 MHz
NO. OF CPUS : 1
CPU HW SUPPORT : 64 BITS
KERNEL SUPPORT : 64 BITS
System Memory : 2048 MB
OS VER : HP-UX B.11.00

I am supposed to do a performance monitoring while load testing. I am not new in subject, just wanted to explore the things to its best. What all you can suggest that will best fit to my requirement. Please suggest.

Regards
Prashant

[Jean-Luc Oudart]

We had to do some similar exercise recently.

You would require :
- the baseline for existing system
- results for different configuration

In term of tools : perfview , glance and statspack for Oracle

Will you use tools to simulate users ?


JL

[doug mielke]

I'd start with the basic ( and free ) tool

sar

sar -A will give everything, and you can run sar commands on it later, to filter just wat you need..


Keeping a sar history will place daily logs in
var/adm/sa ( see sar man page) You can configure sampling intervals.


sar is as powerful as many perf. packages out there, and IMHO, more accurate than many of them as well.

[Paddy_1]

I use HP-Measureware as I can slice and dice the metrics (once in my DB) to see correlations and causalities.

I also like the granularity I see.

[Uday_S_Ankolekar]

I would use perfview to see the performance by disks,cpu,memory,network etc..with historical data.

If you have OV reporter and OV performnace manager you can generate wonderful graphics in HTML format with the help of measureware or Coda. Evaluation license is available for these products from HP.

-USA..

[MANOJ SRIVASTAVA]

Prashant

The best way to start is to use sar , there is a free tool at www.sarcheck.com which you can downlaod and run , this essentially collects data for time periods which you can specify in the cron and at the intervals you want .

Depending on the data collection you can run the report , the report would run on the collected data and is in formatted form with a breif despcrition of what is happening in terms of

Disk activity
Memory
CPU utiliztion
Network

and also some kernel parameters and is very much presentable to management.


Manoj Srivastava

[Steven E. Protter]

Attached are my stock sar scripts, modified from something hp support gave me.

They run background for a user controlled length of time collecting data into a file. Quite useful.

Quite inexpensive. Free.

SEP

[Camel_1]

measureware is good enough for you to collect performance statistics.