Re: TPC-B Benchmark For Oracle7

In <CooA4o.Jr5_at_ncrcae.ColumbiaSC.NCR.COM> John Susag <John.Susag_at_MinneapolisMN.NCR.COM> writes:

=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

Close. Terminals aren't required for TPC-B, but they are for TPC-A. Even worse, with TPC-A there's a built-in "think time" of around 10 seconds. This means for a 100 A-transactions/second system you must include the cost of (10 seconds) * (100 tpsA) = 1000 terminals. $300/terminal isn't too far off, since you must also include the cost of a 5-year warranty on each terminal (TPC rules require that 5 years worth of maintenance on *everything* be included in total cost). The cost of terminals (and networked terminal concentrators) alone for a big system runs in the neighborhood of 40%-50% of total cost.

For TPC-A you must also include the cost of enough disk to store 90 days worth of database history logs. Fortunately, those are 8-hour days, but if a system is doing 1000 transactions every second it generates 1000 * 60 * 60 * 8 * 90 = 2,592,000,000 history records. If a history record is 70 bytes on average, that turns into about 170 GB of disk. For TPC-B, you only need to include 30 days of history. What a break, eh?

Joan Eslinger
wombat_at_sgi.com Received on Mon Apr 25 1994 - 23:49:06 CEST