I have a network appliance nas. I created 1 flex vol/lun/hdisk. I placed 5 databases on it. ( Why not, the nas stripes the load accross the disk anyway )
these are small databases 40 gigs, 10 gigs, etc..
Now i'm seeing performance problems. Should I have created 5 hdisks?
Is there a bottleneck with AIX's LVM?
I see no errors anywhere, jobs just seem to hang, then finish over time. This only occurs when the system starts to get real busy.
Pinned topic Can I run 5 databases on one NAS hdisk/lun/flex vol
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-05-07T17:03:36Z at 2012-05-07T17:03:36Z by SystemAdmin
SystemAdmin 110000D4XK6902 Posts
Re: Can I run 5 databases on one NAS hdisk/lun/flex vol2012-05-07T17:03:36ZThis is the accepted answer. This is the accepted answer.
- orphy 100000E3SF
The good news is, nmon says I'm cpu bound, mem, page, i/o, network look fine.
Now how to find which object is using all of my CPU?
I'm thinking a command like the following should do it.
ps aux | head -1; ps aux | sort -rn +2 | head -10
ps xv |head -1;ps vx|grep wait
sar -P ALL 1 100