Server workload (should I upgrade my RAM and CPU?)

[Surizan Othman]

We has 1 HP-UX Rp5700 as our Oracle 9i database server. I execute command top and vmstat to check on performance. But I don't have any idea what the output is all about. I'm newbie in HP-UX environment. I do need your recommendation either we have to upgrade RAM or CPU to boost up performance. If we have to upgrade RAM, what is the recommended size. I attached top and vmstat for your perusal.

[Jeeshan]

Hi Othman

your vmstat output shows there is not such load. but your memory is overloaded.

give me some answer
1. how much physical and virtual memory you have?
2. how much memory consumed by oracle SGA?
3. is the CPU load is fluctuating?

[Surizan Othman]

Hi Ahsan,

Pertaining to your questions, how can I check those thing. Can you provide me a command to perform that. Can you provide me a step by step guide. I'm not familiar with HP-UX and your help is much appreciated. Thanks

[Wang,MinJie]

I can help you for these three questions

1. Get your size of physical memory by using "dmesg" you'll see a lot of output and you can get the size in the end.
Get your virtual memory by "swapinfo -tm"

2. # su - oracle(swith to oracle user)
$ sqlplus '/ as sysdba'
SQL>startup (start the instance)

Then you will see the SGA size

3. run the top and manually monitor the metrics of cpu to see if it is fluctuated

Regards,
Jay

[Jeeshan]

i think you have already figured out the data collection methods.

also check in your system that, the how much memory and CPU consumed by every process

#export UNIX951;ps -ef -o comm,pcpu,vsz,args

[Jeeshan]

i mistakes the command

#export UNIX95=1;ps -ef -o comm,pcpu,vsz,args

[Surizan Othman]

Attachment is my server output from command you provided. CPU is fluctuating.

[Jeeshan]

hmmmmm

as per your outputs, its obvious that, mostly you are in overloaded with Memory. CPU is a consideration.

If this has been happened for a long period, i think you may go for CPU,Memory upgrade. Also noted that, if you upgrade your Memory, you also need to increase your swap space.

[Torsten.]

There is no rp5700, but I assume it is a rp5400.

Run

# model

to confirm.

Question is, *IF* you can upgrade this server in any way. According to your attachements you already have 2 CPUs installed (this is the maximum).

to get more information run:

# model

# echo "selclass qualifier memory;info;wait;infolog" | /usr/sbin/cstm

# echo "selclass qualifier cpu;info;wait;il"|cstm

[Surizan Othman]

My server model
# model
9000/800/L3000-7x

I attach an output from a command torsten provided

[Torsten.]

Your system is a rp5470 (aka L3000) with 2 750MHz CPU and a single memory extender - so there is room for another mem extender +2 CPUs.

[Ramaprasad K]

Before going ahead with the Mem or CPU upgrade, just see how much of swap is being used up. If swap available is less, then performance would be slow.

share the output of 'swapinfo -tam'

Regards,
Ramprasad

[Surizan Othman]

# swapinfo -tam

Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4096 25 4071 1% 0 - 1 /dev/vg00/lvol2
dev 4096 25 4071 1% 0 - 1 /dev/vg00/lvswap
reserve - 2847 -2847
memory 3068 2016 1052 66%
total 11260 4913 6347 44% - 0 -


What is the recommended memory upgrade