Re: Storage System Bakeoff test plans
Date: Wed, 9 Apr 2008 09:18:54 -0500 (CDT)
I agree. Going through some smaller-scale IO testing right now, and Orion came back with fantastic (but not unrealistic) read throughput numbers for one SAN setup. But in practice, one troublesome query wasn't noticably faster despite originally spending 90% of it's time being IO bound. Why? That one query is still only pulling back 8K at a time from the database.
Turning parallel query on to utilize the SAN bandwidth with the new IO layout proved to be the major bang-for-buck (as well as proper adjustment of the multiblock read factor). Of course, there's a bug in parallel query and NVARCHAR2 bind variable casting that prevents us from using it...<sigh>
So, I believe that Orion is very useful, but the final test is with your database.
> Orion will let you test your IO stack to a certain extent. It's
> Also, to configure Orion correctly, you need to know IO patterns of
> your data warehouse.
> Nothing better than real workload so if you have your DW test system