Re: Advice for perf testing dasd

2010-02-05 Thread Marcy Cortes
Hello Patrick, I don't have a lot of Oracle DB experience, but our acquisition had it up with a prod app. They found Oracle behaved much better with 2 vcpus. It wasn't even using 1/3 of a single z9 IFL at peak, but with 2 vcpus it flew compared to 1. The theory was that Oracle must have writ

Re: Advice for perf testing dasd

2010-02-05 Thread David Boyes
On 2/5/10 7:04 PM, "Patrick Spinler" wrote: > I'm doing some comparison studies on dasd / disk I/O for different > configurations of storage and storage on different virtualization > platforms (trying to convince management that oracle on Z is an okay > thing). I'd really really appreciate any

Re: Advice for perf testing dasd

2010-02-05 Thread Mark Post
>>> On 2/5/2010 at 07:04 PM, Patrick Spinler wrote: > I'd plan to do all this testing on an up to date install of rhel 5.4 in > a single IFL guest, ... Comparing the performance of one instance of Linux for System z to one instance of anything else is likely going to make the System z look anem

Advice for perf testing dasd

2010-02-05 Thread Patrick Spinler
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all: I'm doing some comparison studies on dasd / disk I/O for different configurations of storage and storage on different virtualization platforms (trying to convince management that oracle on Z is an okay thing). I'd really really appreciate an

Re: A Question on Sizing z/VM Linux Guests

2010-02-05 Thread David Boyes
Another handy item for Oracle folks is: http://www.oracle.com/technology/software/tech/orion/index.html Allows you to simulate Oracle I/O loads on disk configurations without actually having to install Oracle and find a database big enough to stress test your filesystem configuration and get your

Re: A Question on Sizing z/VM Linux Guests

2010-02-05 Thread Sterling James
Thanks for the comments. > to set DB2 memory management to "automatic" to let it size itself based on the Linux configuration. Which can be interpreted as, with STMM set (fully) on, DB2 will try to use 85% of configured memory (if it needs it ofr not). Then it's back to guessing how much is really

Re: A Question on Sizing z/VM Linux Guests

2010-02-05 Thread Rob van der Heij
On Fri, Feb 5, 2010 at 4:26 PM, Sterling James wrote: > I realize that it would not be a apples to apples comparison, but is there > a similar discussion about sizing guests that are running DB2? With STMM > on? And the "Be ware!"s? Does DB2 have instrumentation that can tell you > how it's using

Re: A Question on Sizing z/VM Linux Guests

2010-02-05 Thread Sterling James
I realize that it would not be a apples to apples comparison, but is there a similar discussion about sizing guests that are running DB2? With STMM on? And the "Be ware!"s? Does DB2 have instrumentation that can tell you how it's using memory and indicate "good" value. I am aware the STMM is suppos

Re: A Question on Sizing z/VM Linux Guests

2010-02-05 Thread van Sleeuwen, Berry
O, I didn't know that. I'd expected the reported linux cache to be filesystem cache and as such not directly related to oracle. Berry. -Original Message- Be aware! The Oracle SGA lives in Linux page cache, together with in-use programs and shared libraries. So on Oracle systems it is nor

Re: SLES11 and sshfs

2010-02-05 Thread Bernie Wu
Thanks Mark and to all that replied. Guess I will have to build it myself. The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. This message may be an attorney-client communication and/or work product and as suc

Re: A Question on Sizing z/VM Linux Guests

2010-02-05 Thread Rob van der Heij
2010/2/4 van Sleeuwen, Berry : > We have some oracle guests that have been set to 1G. And they actually > need only 300M. The rest is occupied in cache (between 650 and 710M). Be aware! The Oracle SGA lives in Linux page cache, together with in-use programs and shared libraries. So on Oracle syst