On 2/5/10 7:04 PM, "Patrick Spinler" <[email protected]> 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 advice regarding how to > structure and go about doing this testing. Check this link out: http://www.oracle.com/technology/software/tech/orion/index.html Orion is a tool that Oracle wrote to allow you to test and compare filesystem and storage subsystem configurations with a synthetic "Oracle-like" workload without having to install the whole Oracle suite and find a big honking database to muck about with. I've used it a couple of times, and while it's not perfect (you still need to look at your VM performance data), at least it's a known, comparable test workload that you're comparing as close to apples-to-apples as you can probably get. I suspect that your Oracle-doubters might be more convinced if the test is one coming from an actual Oracle-distributed tool. It's available on a bunch of different platforms, including Linux on Z. Orion simulates several different kinds of common database workload patterns, including OLTP and business intelligence/data mining applications. If you use it, make sure you run it for at least 45-60 minutes to let all the various levels of caching and I/O magic reordering, etc stabilize. There are a LOT of different ones, and you want a steady-state measure as part of the suite of measurements. ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
