Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2012-05-07T17:03:36Z by SystemAdmin
SystemAdmin
SystemAdmin
6902 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

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

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

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

      ‏2012-05-07T17:03:36Z  in response to 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