Re: Storage System Bakeoff test plans

On Wed, Apr 9, 2008 at 5:53 AM, April Wells <awells_at_netspend.com> 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

--
http://www.freelists.org/webpage/oracle-l