Re: Oracle7/Sun TPC-A Benchmark results

In article <11i3s7INN38f_at_fbi-news.Informatik.Uni-Dortmund.DE> klaassen_at_wolfgang.informatik.uni-dortmund.de (Othmar Klaassen) writes:
>In article <1992Jun12.195545.28463_at_oracle.us.oracle.com>,
> ddruker_at_us.oracle.com (Daniel Druker) writes:
>|>
>|> ... Transaction Processing Council Benchmark A
>|> ... Sun SPARCserver ... 690MP. 107.28 transactions per second (tpsA)
 .
>|> ...Solaris 2.0. ... ORACLE7.
>|> Total system cost, including hardware, software, and five years of maintenance came
>|> to $1,352,118 or $12,604 per tpsA. ORACLE7 results were achieved through a
>|> combination of new features, including the capabilities of PL/SQL procedures
>|> executing within the RDBMS, hashed clustered indexes, and architectural
>|> enhancements that reduced CPU and memory utilization.
>|>
>|> For further information about Oracle, call Oracle corporate
>|> headquarters at 415/506-7000, or write to Oracle Corporation, 500 Oracle
>|> Parkway, Box 659509, Redwood Shores, CA 94065.
>|>
>|>
>|> Daniel Druker
>|> Senior Consultant
>|> Oracle Corporation
>|>
>|> Disclaimer: These are my opinions and mine alone, and don't reflect the
>|> views or position of my employer.
>|>
>
>My latest list of TPC-A results says:
>
>Sponsor : SUN
>System : SPARCserver 690MP
>Spec.Rev. : 1.0,1.1
>Database : SYBASE SQLServer 4.8.1
>Op. Sys. : SunOS 4.1.2, Sun DBE 1.2
>Tot. Sys. Costs : $855,926.00
>Throughput : 95.41 tpsA
>Price/Perf. : $8,972 per tpsA
>
>That's 12.5 % more tps,
> 60 % more $$
>and 40.5 % more $$ per tpsA, (all for Oracle, of course).
>
>don't you think this posting was a bit too loud for these figures?

Not really -- while the costs are higher, most of the additional cost was added because we used 5 SS-IIs as front-end client systems and had to price SW and HW costs for the these, including 5 years of maintenance. Why 5 systems -- we could only run 256 client users on each system (OS limit). The Sybase benchmark used 2 systems only (I'm not sure how or why they did it) and they priced lower costs systems. We priced current (arguably) systems becuase that is what Sun provided for the benchmark.

Also, we didn't partition the history table into 32 physical tables to avoid a history table insert bottleneck :-) Received on Wed Jun 17 1992 - 04:49:00 CEST