Bryan,
What
"tunings" did you apply to NFS, Filer, etc. ?
Check
below for some recommended values.
Simply comparing filer ops is not a good measure
of performance.
For
example: setting nfs mount options in /etc/vfstab to
hard,
intr, suid, rsize=32738, wsize=32768, proto=udp, vers=3
(which
is a known good configuration), will result in "lower" nfs ops
than
say
using r/wsize=8192, but your thruput will be the same or
better.
If I
read you specs right, you're using 1xFC9 shelf for 2 volumes
?
Assuming you are using the recommended spare disk, you
max.
number
of spindles for say vol0 would be 4.
The
WAFL filesystem improves in performance with increasing
number
of
spindles. Try moving the index's over to vol0, delete vol1 and
expand
vol0
by 2 or more disks. In a small volume environment,
performance will
be
enhanced by placing just the online redo logs onto your local
drive.
Once
you have more spindles you can place them on a seperate volume
on the
filer and mount them over your 2nd GbE link.
It is
ideal to seperate sequential writes (such as redo logs) from random
i/o
over a
separate GbE link and separate volume.
To
ensure your problem isn't the GbE connection, try testing
for
raw
thruput of data by issuing a "dd if=/dev/zero of=/toaster/test
bs=32k"
command. Then umount and remount the filer mount point
(to avoid local caching)
and
read it back. If the numbers are low, you may have
a duplex-mismatch and need
to
ensure auto-negotiation is enabled for the NICs in the
E3500.
Needless to say, ensure Solaris 2.7 has the latest
patches applied and the F840 is using
at
least Data ONTAP 6.0.1R3 or better Data ONTAP 6.1 which is at FCS
on
Also
consult the Technical Reports below for further information:
/M/
Michael Lenzer
Oracle TME
Network Appliance
Inc.
495 East Java Dr
Sunnyvale, CA 94089
USA
Hi ,
My customer setup oracle 8.15 on sun E3500 (Solaris.7)
and put oracle database on filer F840 , but performance is
poor.
Hardware environment as
Filer 840
Giga Ethernet II * 2
FC9 disk shelf * 1
about 350 GB
Sun E3500 (Solaris.7)
Cpu 1 ~ 4
memory 1 GB
giga Ethernet * 2 ( direct to filer )
configuration as
oracle database on
/vol/vol0 use e6 giga ethernet channel
oracle
index
on /vol/vol1 use e7 giga ethernet channel
load data to database table about 70000 records , filer ops 1000 ~
2000
sun 1 cpu usage 30% ~ 40%
even add to 4 cpu (20% ~ 30%, never over 50%) ,
oracle process speed still slow , ops increase just to 2500 ~ 3000
it seems filer wait for sun process oracle data , but I can not
increase cpu load
I tuned filer and sun , gigaethernet and nfs configurations already , but
performance do
not get better.
Could you kind to provide any suggestion or solution for this case
Thanks a lots
Cradle Technology Corp.
Infrastructure Integration Department
Bryan
Yuan
Tel: (886) 2 87682688 Ex: 634
bryany@cradle.com.tw