Page 1301
With all these MP, SMP, and MPP platforms, how can you be certain to make the right choice for your business applications today and tomorrow?
The Transaction Processing Performance Council benchmarks effectively illustrate :
The best single resource from the TPC is probably the Complete Listing of TPC Results and includes up-to-date listings of all TPC/A, B, C, D, and E benchmarks detailing the company sponsor, system, database, operating system tested , and complete five-year costs including all
Page 1302
software and system maintenance support fees.
TPC/A: Online transaction processing (OLTP) test that scales upward to measure database update, disk I/O, and transaction integrity. All costs are divided by the total system cost and measured in Transactions per Second (TPS), when driven from multiple terminals.
TPC/B: Current database stress test (not OLTP) detailing significant disk I/O, transaction integrity, all costs, moderate system and application execution time.
TPC/C: Simulated order entry of five complex, concurrent OLTP transactions; order delivery, payment record entry, status checks, and warehouse stock level environment test, including all costs, measured in Transactions Per Minute (TPM).
TPC/D: New decision support (DS) OLTP for large systems, processing 17 long running "real-world" queries against complex data structures.
TPC/E: New large-business "Enterprise"-database stress test for complex-query processing on very large databases.
TPC Quarterly Reports contain executive summaries of the TPC results published in the quarter as well as a complete historical benchmark listing. Executive summaries are two-page summations of the lengthy Full Disclosure Reports . The summations describe major components , performance data, detailed pricing of the system/configurations, and their related diagrams. Supplementary information included relates to competitive system and database analysis
topics.
Complete Full Disclosure Reports are an average of 100 pages but include detailed price breakdowns by components and the specific optimizations used to achieve the best performance results.
The TPC Price Performance ratio reports are available from within your organization, or you can telephone the TPC for reports and information directly in Sunnyvale, California, at (408) 295-8894.
Following in Table 56.3 are a few sample TPC/A, TPC/C, and TPC/D benchmarks. The TPC consists of 44 members from the hardware and software industry, including
TPC Results are subject to challenge by competitors and independently audited for 60 days prior to their publication. Benchmarks are summarized to include the complete five-year cost of the system including software with full support and administration costs. These figures are then expressed in total Transactions Per Second (TPS), (TPM), and the associated Price Performance Ratio.
Page 1303
Historical IBM 3090 Model 600J performance is 25 TPS, per processor. At six processors, this equates to 150 TPS/A v1.2. These machines cost $6 million to operate for five years , including software, maintenance, and support, thus generating a price performance ratio of $40,000.00@ Transaction. The figures shown in Table 56.3 reflect why the current trend is towards client/server and away from the mainframe.
Table 56.3. Sample TPC benchmarks.
Company | System | TPC/ARev | Throughput | $Price/perf | 5 Yr. Total Cost | RDBMS | O/S | Date |
AT&T | NCR3655/ 48 CPU C/S | v 1.2 | 713.56 TPS/A | $5,941. @TPS/A | $4,239,200.00 | Oracle7 | MP/RASSVR4.2 | 10/93 |
Compaq | Proliant 5000 6/200 1x TCP-C | v 3.3 | 5008.43TPM/C | $87,00 @TPM/C | $432,736.00 | Oracle7.3 | MS Windows NT 4.0 | 8/97 |
Compaq | Prolaint 2500 6/200 1xTCP-C | v3.3 | 2604.77 TPM/C | $94.00 @TPM/C | $244,154.00 | Oracle 7.3 | MS Windows NT 4.0 | 8/97 |
Compaq | Prolinea2000 5864200 | v 1.2 | 240.68TPS/A | $4,890. @TPS/A | $1,176,922.00 | Oracle7.0.15 | SCO UNIX 3.2.4 | 9/93 |
Compaq | system-pro/ XL5862100 | v 1.2 | 242.23TPS/A | $5,130. @TPS/A | $1,242,662.00 | Oracle7.0.15 | SCO UNIX 3.2.4 | 8/93 |
Compaq | system-pro/ XL5862040 | v 1.2 | 171.82TPS/A | $5,437. @TPS/A | $834,146.00 | Oracle7.0.10 | SCO UNIX 3.2.4 | 1/93 |
HP | 9000T500 C/S | v 3.00 | 5070TPM/C | $530.00 @TPM/C | $2,872,151.00 | Oracle7.3 | HP-UX 10.10 | 7/95 |
HP | 9000K410 C/S | v 3.00 | 3809TPM/C | $364.00 @TPM/C | $1,384,763.00 | Oracle7.3 | HP-UX 10.01 | 9/95 |
HP | 9000H70 C/S | v 1.2 | 411.73TPS/A | $6,866. @TPS/A | $2,745,542.00 | Oracle7.0.11 | HP-UX 9.0 | 6/93 |
HP | 9000H50 C/S | v 1.1 | 184.55TPS/A | $8,637. @TPS/A | $1,593,366.00 | Oracle7.0.10 | HP-UX 9.0 | 6/93 |
IBM | ES/9000742 Fastpath | v 1.2 | 1427.07TPS/A | $13,348. @TPS/A | $19,175,741.0 | IMSDB4.1 W RSR | MVS/ESA4.3 | 12/93 |
IBM | RS/6000570 C/S | v 1.2 | 128.50TPS/A | $6,536. @TPS/A | $1,095,880.00 | Oracle7 | AIX3.2.3UNIX | 12/93 |
Sun | Ultra Enterprise 6000 C/S | v 3.3 | 31,104.04 TPM/D | $109,00 @TPM/C | $3,391,878 | Oracle8 | Solaris 2.6 | 9/97 |
Sun | Starfire Ultra Enterprise 10000 | v 1.2 | 4,661 TPM/D | $1,540.00 @TPM/D | $9,767,384 | Oracle8 | Solaris 2.6 | 9/97 |
Sequent | S2000/750 C/S | v 1.2 | 1002.37TPS/A | $9,313. @TPS/A | $9,335,113.00 | Oracle7.0.12 | DYNEXptkV 2.0.1 | 6/93 |
Choosing your parallel processing platform requires specific selection criteria. Decisions you make regarding how you will evaluate the information and select the best current and future solution will have a long- term impact on your entire network user community.
When selecting a platform, consider your real-world experiences with your current file servers: