Re: [zfs-discuss] ZFS - DB2 Performance

2007-06-26 Thread Louwtjie Burger
Roshan Perera writes: > 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 s

RE: [zfs-discuss] ZFS - DB2 Performance

2007-06-26 Thread Ellis, Mike
han Perera Cc: zfs-discuss@opensolaris.org Subject: Re: [zfs-discuss] ZFS - DB2 Performance Possibly the storage is flushing the write caches when it should not. Until we get a fix, cache flushing could be disabled in the storage (ask the vendor for the magic incantation). If

Re: [zfs-discuss] ZFS - DB2 Performance

2007-06-26 Thread Roch - PAE
Possibly the storage is flushing the write caches when it should not. Until we get a fix, cache flushing could be disabled in the storage (ask the vendor for the magic incantation). If that's not forthcoming and if all pools are attached to NVRAM protected devices; then these /etc/

Re: [zfs-discuss] ZFS - DB2 Performance

2007-06-26 Thread eric kustarz
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

Re: [zfs-discuss] ZFS - DB2 Performance

2007-06-26 Thread Roshan Perera
] - Original Message - From: Will Murnane <[EMAIL PROTECTED]> Date: Tuesday, June 26, 2007 2:00 pm Subject: Re: [zfs-discuss] ZFS - DB2 Performance To: Roshan Perera <[EMAIL PROTECTED]> Cc: zfs-discuss@opensolaris.org > On 6/26/07, Roshan Perera <[EMAIL PROTECTED]> wr

Re: [zfs-discuss] ZFS - DB2 Performance

2007-06-26 Thread Will Murnane
On 6/26/07, Roshan Perera <[EMAIL PROTECTED]> wrote: 25K 12 CPU dual core x 1800Mhz with ZFS 8TB storage SAN storage (compressed & RaidZ) Solaris 10. RaidZ is a poor choice for database apps in my opinion; due to the way it handles checksums on raidz stripes, it must read every disk in order

[zfs-discuss] ZFS - DB2 Performance

2007-06-26 Thread Roshan Perera
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) So