Re: [zfs-discuss] Performance Tuning - ZFS, Oracle and T2000

2007-08-20 Thread Neelakanth Nadgir
Damian, Are you using compression=on? There was a bug in the past (fixed now) where if compression was turned on, it was being computed by a single thread. The ZFS team fixed the "user data" part of it (i.e user data is compressed in parallel now), but the meta data part is still compressed by one

Re: [zfs-discuss] Performance Tuning - ZFS, Oracle and T2000

2007-08-20 Thread przemolicc
On Sun, Aug 19, 2007 at 09:32:02AM +0200, Louwtjie Burger wrote: > http://blogs.sun.com/realneel/entry/zfs_and_databases > > http://www.sun.com/servers/coolthreads/tnb/parameters.jsp > > http://www.sun.com/servers/coolthreads/tnb/applications_oracle.jsp > > Be careful with long running single qu

Re: [zfs-discuss] Performance Tuning - ZFS, Oracle and T2000

2007-08-19 Thread Louwtjie Burger
http://blogs.sun.com/realneel/entry/zfs_and_databases http://www.sun.com/servers/coolthreads/tnb/parameters.jsp http://www.sun.com/servers/coolthreads/tnb/applications_oracle.jsp Be careful with long running single queries... you want to throw lots of users at it ... or parallelize as much as p

[zfs-discuss] Performance Tuning - ZFS, Oracle and T2000

2007-08-18 Thread Damian Reed - Systems Support Engineer
Hi All, We are currently in the process of testing Solaris 10 with ZFS and Oracle and are running it on a T2000. When checking performance statistics on the T2000, we notice that only one thread of the CPU appears to be doing any of the processing. Leaving all other threads seemingly idle. A