Performance help

[mouse123]

I have asked this question before also, still I am waiting for some aix expert reply

In the top utility i could see Virtual memory is 0.0M free
Server H50
OS 4.3.3
Memory is 2GB

askprod:/#lsps -a
Page Space Physical Volume Volume Group Size %Used Active Auto Type
paging01 hdisk1 rootvg 1792MB 12 yes yes lv
paging00 hdisk0 rootvg 2048MB 11 yes yes lv
hd6 hdisk0 rootvg 512MB 42 yes yes lv
Here is my top output

askprod#top

askprod load averages: 2.64, 1.82, 1.69 Wed Dec 18 14:58:36 2002
Cpu states: 45.8% user, 16.6% system, 17.5% wait, 20.1% idle
Real memory: 1960.9M free 1463.0M procs 416.1M files 3840.0M total
Virtual memory: 0.0M free 409.6M used 409.6M total

PID USER PRI NICE SIZE RES STAT TIME CPU% COMMAND
108472 oracle 120 0 28969K 12952K run 6:51 24.8% oracle
131758 oracle 109 0 30189K 14164K run 0:01 18.1% oracle
516 root 127 21 12K 7396K run 122542:43 12.5% Kernel (wait)
1290 root 127 21 12K 7396K run 120009:28 11.8% Kernel (wait)
1032 root 127 21 12K 7396K run 119401:20 7.2% Kernel (wait)
774 root 127 21 12K 7396K run 118996:52 6.5% Kernel (wait)
189180 oracle 73 0 28413K 11444K sleep 1:46 5.5% oracle
220202 oracle 75 0 28345K 11628K sleep 0:03 4.6% oracle
82170 oracle 65 0 28701K 12452K sleep 0:30 2.5% oracle
140536 oracle 65 0 30185K 14164K sleep 0:00 2.3% oracle
153856 root 63 0 1032K 1112K run 0:00 1.6% monitor
180388 oracle 62 0 29821K 13804K sleep 0:19 0.9% oracle
1548 root 16 21 12K 7392K sleep 962:24 0.4% Kernel (lrud)
2064 root 37 21 64K 7440K sleep 325:02 0.4% Kernel (gil)
146552 oracle 60 0 28769K 12316K sleep 9:43 0.2% oracle
4164 root 60 0 165K 36K sleep 769:25 0.0% syncd

Also if watch through monitor, the IO is sometime 96% on hdisk2.

AIX monitor v1.14: askprod Wed Dec 18 15:06:15 2002
Sys 8.2% Wait 36.2% User 23.0% Idle 32.5% Refresh: 1.00 s
0% 25% 50% 75% 100%
=====

http://WWWWWWWWWWWWWWWWWWWWWWWWWW>>>>>>>>>>>>>>>>.......................

Runnable processes 1.00 load average: 1.23, 1.40, 1.55

Memory Real Virtual Paging (4kB) Process events File/TTY-IO
free 1962.9 MB 0.0 MB 587.6 pgfaults 1158 pswitch 0 iget
procs 1461.0 MB 409.6 MB 378.7 pgin 6124 syscall 105 namei
files 416.1 MB 12.0 pgout 549 read 0 dirblk
total 3840.0 MB 409.6 MB 0.0 pgsin 324 write 1112209 readch
0.0 pgsout 2 fork 156600 writech
DiskIO Total Summary 3 exec 0 ttyrawch
read 1523.0 kByte/s 0 rcvint 0 ttycanch
write 48.0 kByte/s 0 xmtint 0 ttyoutch
transfers 201.9 tps
active 1/4 disks Netw read write
en0 44.4 119.5 kB/s
TOPdisk read write busy lo0 0.0 0.0 kB/s
hdisk2 1523 48 kB/s 96%
hdisk1 0 0 kB/s 0%
hdisk0 0 0 kB/s 0%
cd0 0 0 kB/s 0%


Should i add another pagging space in hdisk2? or should i add more memory

I need help from expert?

 

[mouse123]

hi Bi

This Oracle Database designed by some one, who is no more with company. I don't know much about oracle and also operating system installed and configured by some one


Here is my email id
logicmailid@yahoo.com

 

[bi]

Don't worry about it. It's not hopeless. But it will probably some downtime or periods of really slow performance while you move things around.

 

[mrn]

Take a look using

sar -d 6 3

This will generate real time disk I/O and is easier to read than vmstat.

Take a look at how your data is placed on the disk. Where possible try to spread high I/O apps accross the centre of the disk(s)

Also check the lv frags

lslv -l hdisk2

PV Copies In Band Distribution
hdisk2 114:000:000 22% 000:042:026:000:046

The output of COPIES shows if the logical volume hdisk2 has only one copy. The In band shows how well the intrapolicy, an attribute of logical volumes is followed. The higher the % the better the allocation efficiency. Each LV has it's own intrapolicy. If the OS cannot meet the requirement, it chooses the best way to meet the requirements. In the example above there are a total of 114 logical partitions. 42 LPs are located on the middle, 26 are located on the centre and 46 LPs on inner-edge. Since the LV intrapolicy is centre, the in-band is 22% (26/ (42+26+46). The distribution shows how the physical partitions are placed in each part of the intrapolicy edge:middle:centre:inner-middle:inner-edge.

If you need any help with the placing of your data or which commands to use, please just ask.

Regards Mike --
| Mike Nixon
| Unix Admin
|

http://www.instantflashshop.com

----------------------------

 

[mouse123]

Hi Mike

Here is the output

askprod:/#sar -d 6 3

AIX askprod 3 4 000095884C00 01/22/03

10:50:13 device %busy avque r+w/s blks/s avwait avserv

10:50:19 hdisk0 0 0.0 1 8 0.0 0.0
hdisk1 0 0.0 0 9 0.0 0.0
hdisk2 21 0.0 79 1020 0.0 0.0
cd0 0 0.0 0 0 0.0 0.0


10:50:25 hdisk0 1 0.0 2 10 0.0 0.0
hdisk1 1 0.0 3 12 0.0 0.0
hdisk2 92 0.0 161 1299 0.0 0.0
cd0 0 0.0 0 0 0.0 0.0


10:50:31 hdisk0 0 0.0 2 9 0.0 0.0
hdisk1 1 0.0 1 5 0.0 0.0
hdisk2 48 0.0 82 634 0.0 0.0
cd0 0 0.0 0 0 0.0 0.0


Average hdisk0 0 0.0 1 9 0.0 0.0
hdisk1 0 0.0 1 8 0.0 0.0
hdisk2 53 0.0 107 984 0.0 0.0
cd0 0 0.0 0 0 0.0 0.0

askprod:/#lslv -l hdisk2
0516-306 lslv: Unable to find hdisk2 in the Device
Configuration Database.

The hdisk2(logical disk) is configured ssa 16 phisical disk

Can also send me commands for placing data

Still my virtual memory shows zero

Thanks

 

[nnconcerts]

I was told to keep paging space to the very same size as the one on hdisk0 such as 512Mb and subsequently 512Mb on other hdisks. If it becomes larger than this, you will have disk thrashing. The memory is quite enough now. Besides you don't have disk thrashing, but adding more memory can help. Virtual memory is the disk space and you don't need if you have adequate memory. So, what is the problem here?

 

[Robnhood]

Historically I have always keep a paging space on hdisk0 equal to installed ram so that I would always have a dump device and put additional paging spaces elsewhere. Craig

http://www.SecurelySpeaking.com

 

[arvibm]

Pls set the default vaule of some parameter which i am forwording to
you.This will help in performance improvement

This can be set by the command /usr/kernel/sample/vmtune
-f minfree 120xN (default) if 4 cpu it is 480
-F maxfree 128xN (default) 512
-R = maxfree -minfree =32
-P min perm 5
-p macperm 10
-s 1
-b 200
-B 800

This entry u have to put in the /etc/rc before the mount all command...

second one is for FASTt500:-


This info is generally applicable to AIX systems
using FAStT storage.

Config/tuning parameters for AIX using FAStT:

FC adapter attribute changes:

lg_term_dma from 0x200000 to 0x1000000
(from 2 MB to 16 MB)

#lattr -El fcs0
#chdev -l fcs0 -a lg_term_dma=0x1000000 -P
#cfgmgr
#lsattr -El fcs0

num_cmd_elems from 200 to 1024

#lattr -El fcs0
#chdev -l fcs0 -a num_cmd_elems=1024 -P
#cfgmgr
#lsattr -El fcs0

DAR attribute changes:

load_balancing was set to yes

#lsattr -El dar0
#chdev -l dar0 -a load_balancing=yes
#lsattr -El dar0

autorecovery was set to yes

#lsattr -El dar0
#chdev -l dar0 -a autorecovery=yes
#lsattr -El dar0

hdisk attribute changes: [VG must be varied-off]

queue_depth from the default to 16

#lsattr -El hdisk
#chdev -l hdiskX queue_depth=16
#lsattr -El hdisk

prefetch_mult from 0 to 8

#lsattr -El hdisk
#chdev -l hdiskXX prefetch_mult=8
#lsattr -El hdisk

I hope this will improve ur performance.