Re: Oracle Benchmark Results for Different Hardware Configurations?

"HansF" <Fuzzy.Greybeard_at_gmail.com> wrote in message news:pan.2006.09.12.03.43.51.802862_at_gmail.com...
> On Tue, 12 Sep 2006 00:07:04 +0000, Bob Jones wrote:
>
>>
>> "HansF" <Fuzzy.Greybeard_at_gmail.com> wrote in message
>> news:pan.2006.09.11.20.38.56.401596_at_gmail.com...
>>> On Mon, 11 Sep 2006 14:05:59 +0200, Lav Kovacic wrote:
>>>
>>>> Does anyone know where I can find any Oracle DB related benchmark
>>>> results
>>>> for different configurations of hardware?
>>>
>>> http://www.tpc.org ???
>>>
>>
>> Two issues with the site:
>>
>> 1. You may not find the exact configurations.
>
> In order for a benchmark to be published, the exact confirguration must be
> defined in the benchmark.
>

What I meant was OP's exact configurations.

> Whether you can purchase such a configuration is immaterial ... at least
> you know what is similar and what is significantly different.
>

We are not talking about whether you can purchase similar equipments. We are talking about whether you can evaluate your configurations using tpc.org as a guide or even a clue.

>> 2. You will not likely archive the same performance with your
>> applications.
>
> Very true. Few people, or organizations, are willing to put in the effort
> to do that level of tuning - and the tuning only needs to be valid for a
> relatively short period of time.
>

Not just the level of tuning, but more importantly the type of applications.

>
>> So what's the point? If you already have the hardware, why not test it
>> yourself.
>
> That is Oracle's official stance.
>
> Yet - when trying to determine which hardware to get it is useful to have
> some starting point, no matter how artifically derived. There are a large
> number of variables in any benchmark and the TPC at least makes some
> attempt to define them and to hold some of them to a relative constant.
> (Then at least you have some ammo when trying to get a discount on the
> equipment management has already, behind your back, decided to purchase.)
>

If a large number of variables do not matter, then one could use a HP's hardware benchmark to be the starting point of a Sun purchase.

>
> In any case, benchmarking anything other than the application to be run,
> with the specific resources that will be used to keep it tuned, is rather
> a moot point.

Exactly.

>(So is breathing - you're gonna die sometime anyway so why
> bother?)
>

You don't live just to breathe or do meaningless stuff. Received on Tue Sep 12 2006 - 19:45:26 CDT