On Jun 26, 2007, at 4:26 AM, Roshan Perera wrote:
Hi all,
I am after some help/feedback to the subject issue explained below.
We are in the process of migrating a big DB2 database from a
6900 24 x 200MHz CPU's with Veritas FS 8TB of storage Solaris 8 to
25K 12 CPU dual core x 1800Mhz with ZFS 8TB storage SAN storage
(compressed & RaidZ) Solaris 10.
Unfortunately, we are having massive perfomance problems with the
new solution. It all points towards IO and ZFS.
Couple of questions relating to ZFS.
1. What is the impace on using ZFS compression ? Percentage of
system resources required, how much of a overhead is this as
suppose to non-compression. In our case DB2 do similar amount of
read's and writes.
2. Unfortunately we are using twice RAID (San level Raid and RaidZ)
to overcome the panic problem my previous blog (for which I had
good response).
3. Any way of monitoring ZFS performance other than iostat ?
4. Any help on ZFS tuning in this kind of environment like caching
etc ?
Have you looked at:
http://blogs.sun.com/realneel/entry/zfs_and_databases
http://blogs.sun.com/realneel/entry/zfs_and_databases_time_for
?
eric
Would appreciate for any feedback/help wher to go next.
If this cannot be resolved we may have to go back to VXFS which
would be a shame.
Thanks in advance.
_______________________________________________
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
_______________________________________________
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss