This discussion is archived
3 Replies Latest reply: Apr 22, 2013 7:12 AM by Reidod RSS

zpool concat performance

831265 Newbie
Currently Being Moderated
Hi,

We have a zpool for a Oracle data area as below.

Unfortunately we have very slow performance on the zpool (and very bad backup performance as well) so I was wondering if anyone had any thoughts about zpool/zfs performance on a concatenated volume.. Ive read the usual performance guides but a couple of forums said the performance could be worse with a concat volume especially on an intensive Production read/write volume.

oradata 1.76T 272G 906 265 13.7M 3.47M
c3t60060E800544C900000044C90000105Ad0 1.56T 270G 811 192 12.2M 3.10M
c3t60060E800544C900000044C90000105Bd0 198G 1.30G 94 73 1.43M 377K

for info, the server is an M5000 running Solaris 10.




Thanks.
  • 1. Re: zpool concat performance
    cindys Pro
    Currently Being Moderated
    I don't understand what you mean by a concatenated volume. Are you referring to some underlying hardware RAID config?
    I see a non-redudant ZFS storage pool of 2 LUNs so data is striped across each LUN.

    There are several ways to improve the performance of an Oracle database:

    1. Hardware RAID or a mirrored ZFS storage pool is recommended.
    2. Which Solaris 10 release is this? The latest Solaris 10 release is recommended.
    3. How many db file systems and how are they configured. A separate (small) pool for the redo log is also recommended.

    You can read about these recommendations here:

    http://docs.oracle.com/cd/E26505_01/html/E37386/chapterzfs-db1.html#chapterzfs-db2

    Thanks, Cindy
  • 2. Re: zpool concat performance
    Bulls123 Newbie
    Currently Being Moderated
    Yes, as far as my understanding there is no concat / stripe in zpool, it takes all as a single disk once bring it under zpool control. check out the IO operations and if possible, try to install Oracle in a local disk and see a performance...to decide if there is a problem in LUN.
  • 3. Re: zpool concat performance
    Reidod Explorer
    Currently Being Moderated
    Hi,

    It is not advisable to set up zfs pools or file systems on top of SVM volumes. This configuration can cause performance issues.

    Regards,
    Rei

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points