Re: Storage System Bakeoff test plans

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: awells@xxxxxxxxxxxx
  • Date: Wed, 16 Apr 2008 10:54:38 -0700

On Wed, Apr 9, 2008 at 5:53 AM, April Wells <awells@xxxxxxxxxxxx> wrote:

>  We are looking at doing a 'bakeoff' between three different storage
> vendors and I 'get' to do the test plan (as well as implement most of the
> plan).
>
> Has anyone used the Oracle Orion tool?  The claim is that is all that we
> should have to use to load test the data warehouse on these three
> platforms.  I'm not sure I buy it, but I would welcome the input of anyone
> who has actually used the tool.  How is it at OLAP profiling?
>

I kind of like SwingBench http://www.dominicgiles.com/swingbench.html

It does require installing an Oracle database, which is kind of the point.

I want to see how oracle performs, not a simulation of Oracle.

While it may not exactly characterize the workload we have, it is better
than just
using something like ioZone, though I do intend to use ioZone. ( I have some
benchmarking
to do this week)

There is a facility to create your own workloads with this tool as well.

What I like to see is how far I have to push the server to saturate the
cache, and see
server phsyical IO climb, server logical IO decline, until they meet.

The only way to truly characterize your workload is with a tool such as
replay
(extra cost option in 11g) or with something like James Morle's simora
http://sourceforge.net/projects/simora/


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: