Re: Storage System Bakeoff test plans

Orion will let you test your IO stack to a certain extent. It's claimed to use the same IO calls and oracle code that used in Oracle itself.
What Orion can do is to simulate small and large IOs in random of sequential (for large IOs) order and combinations of it. In real systems, IO is never 100 random so you will have some traffic patterns.
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 that can be loaded like in production - go for it by all means. Make sure you take appropriate measurements of response time of all tasks. That's what makes sense to compare and not number of IOs and etc.

On 9-Apr-08, at 8:53 AM, April Wells 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 am of the opinion that we ought to run actually “stuff” through
> the warehouse to test the performance (you know, things like the
> nightly ETL job at the same time we run the query from… well… you
> know) but it looks like I may be out voted. Opinions?
>
> We are planning on running one day of normal type processing, one
> day of ‘the heaviest season of the year’ and one day of ‘all the
> users in the world are hitting it’… but all programmed with Orion…
> Suggestions?
>
> Thanks in advance for any advice…
> April
>
>
>
>
>
>
> Confidentiality Notice!
> This electronic transmission and any attached documents or other
> writings are confidential and are for the sole use of the intended
> recipient(s) identified above. This message may contain information
> that is privileged, confidential or otherwise protected from
> disclosure under applicable law. If the receiver of this
> information is not the intended recipient, or the employee, or
> agent responsible for delivering the information to the intended
> recipient, you are hereby notified that any use, reading,
> dissemination, distribution, copying or storage of this information
> is strictly prohibited. If you have received this information in
> error, please notify the sender by return email and delete the
> electronic transmission, including all attachments from your
> system.
>
>
>
>
>
>
> Confidentiality Notice!
> This electronic transmission and any attached documents or other
> writings are confidential and are for the sole use of the intended
> recipient(s) identified above. This message may contain information
> that is privileged, confidential or otherwise protected from
> disclosure under applicable law. If the receiver of this
> information is not the intended recipient, or the employee, or
> agent responsible for delivering the information to the intended
> recipient, you are hereby notified that any use, reading,
> dissemination, distribution, copying or storage of this information
> is strictly prohibited. If you have received this information in
> error, please notify the sender by return email and delete the
> electronic transmission, including all attachments from your
> system.
>
>

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