Topic
  • 2 replies
  • Latest Post - ‏2012-05-07T17:03:36Z by SystemAdmin
SystemAdmin
SystemAdmin
6902 Posts

Pinned topic Can I run 5 databases on one NAS hdisk/lun/flex vol

‏2012-05-02T22:32:17Z |
Hello AIX'ers,

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.

Thank you!
Patrick.
Updated on 2012-05-07T17:03:36Z at 2012-05-07T17:03:36Z by SystemAdmin
  • orphy
    orphy
    480 Posts

    Re: Can I run 5 databases on one NAS hdisk/lun/flex vol

    ‏2012-05-02T22:41:28Z  
    Why not collect some performance data (e.g. nmon) and look at where the bottleneck is?
    Orphy
  • SystemAdmin
    SystemAdmin
    6902 Posts

    Re: Can I run 5 databases on one NAS hdisk/lun/flex vol

    ‏2012-05-07T17:03:36Z  
    • orphy
    • ‏2012-05-02T22:41:28Z
    Why not collect some performance data (e.g. nmon) and look at where the bottleneck is?
    Orphy
    Yeah really, speculation is good but facts help make better decisions.
    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