Re: TPC-B Benchmark For Oracle7

>In article <20APR199411205987_at_ccnova.sunysb.edu> Sanjay Kapur writes:
>In article <2p1ngu$han_at_fido.asd.sgi.com>, sreiss_at_powerplay.engr.sgi.com (Steve
 Reiss) writes...
>>In article <CoIpzs.542_at_encore.com>, maldred_at_pinocchio.encore.com (Mark
>>Aldred) writes:
>>|> > I'm currently Beta-testing NT Advanced Server for which I have
>>|> > TPC-B statistics. I would like to do a comparison of NTAS and
>>|> > Oracle7 using this as ONE of the differentiators.
 

>>|> > Cheers,
 

>>|> > Alan N. Turner
>>|>
>>|> Encore Computer recently announced a TPC-B number of 1054 tps at
>>|> $2,801 per tpsB. This benchmark was performed on an Encore Infinity
>>|> 90/ES
>>|> running 15 instances of Oracle with Parallel Server Option
>>
>>
>>If you are looking for high TPC-B numbers to compare against, then the
>>highest TPC-B result is from Silicon Graphics Computer Systems.
>>
>>We achieved 1786.20 tps-b at a cost of $1,610/tps. This was on a 28 CPU
>>Challenge XL server running Oracle 7.0.15.4.1
>>
>>Steven Reiss Silicon Graphics, Inc.
>>sreiss_at_sgi.com 2011 N. Shoreline Blvd
>
>The original question was about NTAS based machines. Under most circumstances
>that would nowadays imply a Pentium with say 64MB of memory, and 10 GB of disk
>and software etc. The total price would be under $25,000.
>
>What is the highest TPC-A, TPC-B or the newly announced TCP-C for a machine
>costing under $25,000? The Encore machine and the SGI machine both are in the
>three million dollar range and are basically competing for the dollars of
>very large IBM mainframe customers which are very few and dwindling in number.
>
>Therefore, my challenge to all the vendors on the net:
>
>What is the highest TPC-x number for your system that cost under $25,000?
>
>I believe $25,000 would be the upper limit most small businesses and
>departments in larger businesses or other institutions would put up for a
>database server.
>
>Another useful comparison would be with minicomputers like the VAX/DEC 4000
>series or the SUN Sparcenter 1000 series. In that case,
>
>What is the highest TPC-x number for your system that cost
>under $50,000? under 100,000?
>
>I believe $100,000 would be the upper limit most medium sized businesses and
>larger departments in larger businesses would put up for a database server.
>
>The real trick is not to make a fast machine, but a fast machine that is both
>reliable and affordable.

It's tough to do a TPC-B test on a system for under $25K due to TPC rules. The TPC rules require you to scale the database as you add users. This means, more disk & memory. You also must include cost of ownership (maintanence). You also must include the cost of terminals for all your users. If you see someone report 1000 tps, they've got the cost of 1000 terminals (at a couple hundred dollers a pop) included.

Say I want to do 100 tps. That means 100 * $300/terminal (picked that out of the air) = $30 K just for terminals. Ouch.

John.Susag_at_MinneapolisMN.NCR.COM
AT&T Global Information Solutions
Opinions expressed are mine alone - Don't blame anyone else Received on Fri Apr 22 1994 - 20:02:48 CEST