La lecture en ligne est gratuite
Le téléchargement nécessite un accès à la bibliothèque YouScribe
Tout savoir sur nos offres

Partagez cette publication

Du même publieur













Hewlett-Packard Company
_______________________________
TPC Benchmark? C

Full Disclosure Report
for
HP Integrity rx2600
Using
Oracle Database 10g Standard Edition One and
Red Hat Enterprise Linux AS 3
_______________________________








Second Edition
October 6, 2004
1 HP Integrity rx2600 TPC Benchmark C FDR.doc
© 2004 Hewlett Packard Company. All rights reserved.
Second Edition October 6, 2004

Hewlett Packard Company (HP) believes that the information in this document is accurate as of the publication date. The
information in this document is subject to change without notice. HP assumes no responsibility for any errors that may
appear in this document. The pricing information in this document is believed to accurately reflect the current prices as of the
publication date. However, HP provides no warranty of the pricing information in this document.

Benchmark results are highly dependent upon workload, specific application requirements, and system design and
implementation. Relative system performance will vary as a result of these and other factors. Therefore, TPC Benchmark C
should not be used as a substitute for a specific customer application benchmark when critical capacity planning and/or
product evaluation decisions are contemplated.

All performance data contained in this report were obtained in a rigorously controlled environment. Results obtained in other
operating environments may vary significantly. HP does not warrant or represent that a user can or will achieve similar
performance expressed in transactions per minute (tpmC) or normalized price/performance ($/tpmC). No warranty of system
performance or price/performance is expressed or implied in this report.

Copyright 2004 Hewlett Packard Company.

All rights reserved. Permission is hereby granted to reproduce this document in whole or in part provided the copyright
notice printed above is set forth in full text or on the title page of each item reproduced.

Printed in U.S.A., 2004

Parallel Database Cluster Model PDC and ProLiant are registered trademarks of Hewlett Packard Company.

ORACLE 10i, Pro*C, PL/SQL, SQL*Net, SQL*Plus are registered trademarks of Oracle Corporation.

TPC Benchmark is a trademark of the Transaction Processing Performance Council.

All other brand or product names mentioned herein must be considered trademarks or registered trademarks of their respective
owners.



2 HP Integrity rx2600 TPC Benchmark C FDR.doc
© 2004 Hewlett Packard Company. All rights reserved.


Table of Contents

TABLE OF CONTENTS................................................................................................................................................................................. 3
PREFACE.......................................... 5
TPC BENCHMARK C OVERVIEW.....................................................................................................................................................................5
ABSTRACT...................................... 6
OVERVIEW..........................................................................................................................................................................6
TPC BENCHMARK C METRICS........6
STANDARD AND EXECUTIVE SUMMARY STATEMENTS...........................................................................................................................6
AUDITOR............................................................................................................6
GENERAL ITEMS ............................................................................................ 7
APPLICATION CODE AND DEFINITION STATEMENTS..............................................................................................................................7
TEST SPONSOR...................................7
PARAMETER SETTINGS....................................................................................7
CONFIGURATION ITEMS...................................................................................................................7
CLAUSE 1 RELATED ITEMS ....................................................................... 9
TABLE DEFINITIONS.........................................................................................................................................................................................9
PHYSICAL ORGANIZATION OF DATABASE...................9
Priced Configuration:................ 9
INSERT AND DELETE OPERATIONS...............................................................................................................................................................9
PARTITIONING...................................................................9
REPLICATION, DUPLICATION OR ADDITIONS............................................................................................................9
CLAUSE 2 RELATED ITEMS .....................................10
RANDOM NUMBER GENERATION.................................................................................................................................10
INPUT/OUTPUT SCREEN LAYOUT...............................10
PRICED TERMINAL FEATURE VERIFICATION............10
PRESENTATION MANAGER OR INTELLIGENT TERMINAL.......................................................................................................................10
TRANSACTION STATISTICS...........................................................................11
QUEUING MECHANISM...................11
CLAUSE 3 RELATED ITEMS.....................................................................................................12
TRANSACTION SYSTEM PROPERTIES (ACID)............................................12
ATOMICITY.....................................................................12
Completed Transactions..........................................................................................................12
Aborted Transactions...............................................12
CONSISTENCY ..................................................................12
ISOLATION........................................................................................................12
DURABILITY....................................12
Durable Media Failure............................................12
Loss of Data................................................................................................................................13
Loss of Log..................................13
Instantaneous Interruption, Loss of Memory.......13
CLAUSE 4 RELATED ITEMS .....................................................................................................................................15
INITIAL CARDINALITY OF TABLES..............................................................15
3 HP Integrity rx2600 TPC Benchmark C FDR.doc
© 2004 Hewlett Packard Company. All rights reserved.

DATABASE LAYOUT .......................................................................................................................................................................................15
TYPE OF DATABASE15
DATABASE MAPPING.....................16
60 DAY SPACE .................................................................................................................................................................................................16
CLAUSE 5 RELATED ITEMS.....17
THROUGHPUT ..................................................................................................................................................................................................17
RESPONSE TIMES.............................17
KEYING AND THINK TIMES...........17
RESPONSE TIME FREQUENCY DISTRIBUTION CURVES AND OTHER GRAPHS......................................................................................17
STEADY STATE DETERMINATION..............................................................................................22
WORK PERFORMED DURING STEADY STATE...........................................22
MEASUREMENT PERIOD DURATION...........................................................................................23
REGULATION OF TRANSACTION MIX .........................................................................................23
TRANSACTION STATISTICS...........................................................................................................................................................................23
CHECKPOINT COUNT AND LOCATION........................24
CDURATION................ERROR! BOOKMARK NOT DEFINED.
CLAUSE 6 RELATED ITEMS .....................................................................................................................................................................25
RTE DESCRIPTIONS.........................................................25
EMULATED COMPONENTS............25
FUNCTIONAL DIAGRAMS...............................................................................................................................................25
NETWORKS.......................................................................25
OPERATOR INTERVENTION..........25
CLAUSE 7 RELATED ITEMS.....................................................................................................................................26
SYSTEM PRICING.............................................................................................26
AVAILABILITY, THROUGHPUT, AND PRICE PERFORMANCE...................................................................................................................26
COUNTRY SPECIFIC PRICING........................................26
USAGE PRICING................................................................................................................................................................26
CLAUSE 9 RELATED ITEMS.....27
AUDITOR’S REPORT .......................................................................................................................................................................................27
AVAILABILITY OF THE FULL DISCLOSURE REPORT................................28
APPENDIX A: SOURCE CODE..................................................................................................................................29
APPENDIX B: DATABASE DESIGN.......................78
APPENDIX C: TUNABLE PARAMETERS............................................................................................................................................100
APPENDIX D: THIRD PARTY LETTERS.............102
APPENDIX E: DATABASE PRICING...................................................................................... ERROR! BOOKMARK NOT DEFINED.

4 HP Integrity rx2600 TPC Benchmark C FDR.doc
© 2004 Hewlett Packard Company. All rights reserved.


Preface


The TPC Benchmark C was developed by the Transaction Processing Performance Council (TPC). The TPC was founded to define
transaction processing benchmarks and to disseminate objective, verifiable performance data to the industry. This full disclosure
report is based on the TPC Benchmark C Standard Specifications Version 5.2, released December, 2003.

TPC Benchmark C Overview
The TPC describes this benchmark in Clause 0.1 of the specifications as follows:

TPC Benchmark C is an On Line Transaction Processing (OLTP) workload. It is a mixture of read-only and update intensive
transactions that simulate the activities found in complex OLTP application environments. It does so by exercising a breadth of
system components associated with such environments, which are characterized by:

• The simultaneous execution of multiple transaction types that span a breadth of complexity
• On-line and deferred transaction execution modes
• Multiple on-line terminal sessions
• Moderate system and application execution time
• Significant disk input/output
• Transaction integrity (ACID properties)
• Non-uniform distribution of data access through primary and secondary keys
• Databases consisting of many tables with a wide variety of sizes, attributes, and relationships
• Contention of data access and update

The performance metric reported by TPC-C is a “business throughput” measuring the number of orders processed per minute.
Multiple transactions are used to simulate the business activity of processing an order, and each transaction is subject to a
response time constraint. The performance metric for this benchmark is expressed in transactions-per-minute-C (tpmC). To be
compliant with the TPC-C standard, all references to tpmC results must include the tpmC rate, the associated price-per-tpmC, and
the availability date of the priced configuration.

TPC-C uses terminology and metrics that are similar to other benchmarks, originated by the TPC or others. Such similarity in
terminology does not in any way imply that TPC-C results are comparable to other benchmarks. The only benchmark results
comparable to TPC-C are other TPC-C results conformant with the same revision.

Despite the fact that this benchmark offers a rich environment that emulates many OLTP applications, this benchmark does not
reflect the entire range of OLTP requirements. In addition, the extent to which a customer can achieve the results reported by a
vendor is highly dependent on how closely TPC-C approximates the customer application. The relative performance of systems
derived from this benchmark does not necessarily hold for other workloads or environments. Extrapolations to other environments
are not recommended.

Benchmark results are highly dependent upon workload, specific application requirements, and systems design and
implementation. Relative system performance will vary as a result of these and other factors. Therefore, TPC-C should not be used
as a substitute for a specific customer application benchmark when critical capacity planning and/or product evaluation decisions
are contemplated.
5 HP Integrity rx2600 TPC Benchmark C FDR.doc
© 2004 Hewlett Packard Company. All rights reserved.

Abstract

Overview
This report documents the methodology and results of the TPC Benchmark C test conducted on the hp integrity rx2600. The
operating system used for the benchmark was Red Hat Enterprise Linux AS 3 . The DBMS used was Oracle Database 10g
Standard Edition.

TPC Benchmark C Metrics
The standard TPC Benchmark C metrics, tpmC (transactions per minute), price per tpmC (three year capital cost per measured
tpmC), and the availability date are reported as:

51,506.4 tpmC
$1.81 per tpmC
Available as of October 6, 2004.

Standard and Executive Summary Statements
The following pages contain an executive summary of results for this benchmark.

Auditor
The benchmark configuration, environment and methodology were audited by Lorna Livingtree of Performance Metrics Inc. to
verify compliance with the relevant TPC specifications.
6 HP Integrity rx2600 TPC Benchmark C FDR.doc
© 2004 Hewlett Packard Company. All rights reserved.

TPC-C Version 5.3 HP Integrity rx2600
Report Date
C/S with 2 ProLiant ML110
September 29, 2004
Revised Date
October 6, 2004
Total System Cost TPC-C Throughput Price/Performance Availability Date
$93,217 USD 51,506 tpmC $1.81 USD/ tpmC September 29, 2004
Processors Database Operating System Other Software Number of
Manager Users
2 x 1.3GHz Intel Oracle Database Red Hat Enterprise Microsoft COM+ 40800
Itanium2 3M 10g Standard Linux AS 3
Processors – Edition One
Server
2 x Xeon
3.0GHz – Client



Giga-bit Switch
HP Integrity rx2600-2
HP MSA30
HP ProLiant ML110
Server Each Client
Quantity Description Quantity Description System Components
Processor 2 1.3 GHz Itanium2 3M 2 3.0GHz Xeon
w/ 3MB Cache w/ 256K cache
Memory 12 2GB 1 1024MB
Disk Controllers 4 HP SMART Array 1 Integrated SMART
Controller 5302/128 5i Controller
Integrated SCSI 1
Controller
Disk Drives 84 18GB 15K SCSI Drives 1 40 GB ATA Drive
146GB 10K SCSI 2
Drives
Total Storage 1804 GB 40 GB



HP Integrity rx2600 TPC Benchmark C ES.doc


TPC-C Version 5.3
HP Integrity rx2600 1.30GHz/3MB 2P
Report Date: 29-Sep-04
Extended 3 yr. Maint.
Description Part Number Third Party Unit Price Qty
Price Price
Brand PricingServer Hardware
HP Integrity rx2600, Intel Itanium2 processor 1.30GHz with 3MB L3 cache A6870B 1 5,195 1 5,195
Single power supply,1-Year Limited Warranty, Core I/O (2NICs, Mgt LAN,
U320 SCSI, RS-232 sp, VGA, USB)
36GB Ultra 320 SCSI 15,000 rpm Hard Drive A9896A 1 760 1 760
150 1DVD-ROM Drive A9919A 1 150
Intel Itanium2 processor 1.30GHz with 3MB L3 cache A9872A 1 3,200 1 3,200
AB228A8GB PC2100 DDR SDRAM memory quad (4x2GB DIMMs) 1 9,460 3 28,380
146GB Pluggable Ultra320 SCSI 10,000 rpm Hard Drive (DB Log) A9898A 1 1,910 2 3,820
Smart Array 5302/128MB Cache Controller A9825A 1 1,399 4 5,596
Smart Array Internal Cables for rx2600 A9827A 1 65 1 65
A7861#ABAUSB Keyboard kit PC-104/105 (inc. USB Kydb and USB mouse) 1 25 1 25
HP S5500 color monitor (carbon/silver 15-inch CRT) P9006A#ABA 1 129 1 129
TR5 10/20-Gigabyte Tape Drive - Carbon 294243-B22 1 299 1 299
Pro UPS 500 (500VA/300 Watts; 110-127 VAC,60 Hz) 136386-001 1 146 1 146
120663-B21Rack Model 9142 (42U - Opal) - Flat Pallet 1 1,321 1 1,321
120670-B21Rack Sidewall Kit 1 207 1 207
3YR 24X7/4HR for HP Integrity rx2600 HA110A3-6BT 1 2,488 1 2,488
Server Hardware Subtotal 49,293 2,488
External Storage 1
302969-B21StorageWorks Enclosure Model MSA 30 SB - Rack-mountable 1 2,978 6 17,868
18.2GB 15Krpm U320 UNI HDD 286775-B22 1 269 84 22,596
18.2GB 15Krpm U320 UNI HDD (10% spares) 1 269 9 2,421
FM-4E724-36 3YR 24X7/4HR EMPTY DISK ENCL 171242-002 157 6 942
Server External Storage Subtotal 40,464 3,363
Server Software
T2744AA-324Red Hat Enterprise Linux AS 3.0 HP 1 1,908 1 1,908
3 Yrs 24 x 7 Support Contract for Red Hat Enterprise Linux AS 3.0 HA110A3-6L4 HP 1 4,839 1 4,839
run-timeOracle Database 10g Standard Edition One for 3 years, Per Processor, Unlimited Users Oracle 2 2,498 2 4,995
Oracle Database Server Support Package for 3 years run-time Oracle 2 2,000 3 6,000
Server Software Subtotal 6,903 10,839
Client Hardware
HP ProLiant ML110 - ATA Model, 3.0GHz/800MHz, 1GB, 40GB, 24x7 4-Hr, 3Yrs 359661-xx1 1 1,315 2 2,630 896
PCI Gigabit NIC (embedded) 10/100/1000 WOL (Wake on LAN)
Client Hardware Subtotal 2,630 896
Client Software
C11-00821Microsoft Windows 2000 Server Microsoft 4 738 2 1,476 Included
Client Software Subtotal 1,476
User Connectivity
NetGear GS105 5-port Gigabit Ethernet Switch 10/100/1000 Mbps GS105 NetGear 5 70 3 210
Connectivity Subtotal 210
Large Purchase and Net 30 discount 30.0% 1 ($14,330) ($746) 16.0% 1 ($7,140) ($681) 23.0% 1 ($439) ($1,113)
Total $79,068 $14,149
Prices used in TPC benchmarks reflect the actual prices a customer would pay for a one-time
purchase of the stated components. Individually negotiated discounts are not permitted. Special
prices based on assumptions about past or future purchases are not permitted. All discounts Three-Year Cost of Ownership: $93,217 USD
reflect standard pricing policies for the listed components. For complete details, see the pricing
sections of the TPC benchmark pricing specifications. If you find that the stated prices are not tpmC Rating: 51,506
available according to these terms, please inform the TPC at pricing@tpc.org. Thank you.
Pricing: 1=HP 2= Oracle 3=Red Hat 4=Microsoft 5=ecost.com. $ / tpmC: $1.81 USD
Oracle pricing contact: Mary Beth Pierantoni, mary.beth.pierantoni@oracle.com, 916-315-5081
Note 1 : Discount based on HP Direct guidence with large purchase discount.
The benchmark results and test methodology audited by Lorna Livingtree of Performance Metrics, Inc.

HP Integrity rx2600 TPC Benchmark C ES.doc
Numerical Quantities Summary
MQTH, Computed Maximum Qualified Throughput 51506.4 tpmC

Response Times (in seconds) Average 90% Maximum
New-Order 0.168 0.202
Payment 0.154 0.186 1.812
Order-Status 0.164 0.201 1.383
Delivery (interactive portion) 0.102 0.102 0.978
Delivery (deferred portion) 0.138 0.173 0.117
Stock-Level 0.061 0.108 1.005
Menu 0.102 0.102 0.625
Transaction Mix, in percent of total transaction
New-Order 44.914%
Payment 43.021%
Order-Status 4.020%
Delivery 4.025%
Stock-Level 4.020%
Emulation Delay (in seconds) Resp.Time Menu
New-Order 0.10 0.10
Payment 0.10 0.10
Order-Status 0.10 0.10
Delivery (interactive) 0.10 0.10
Stock-Level 0.10 0.10
Keying/Think Times (in seconds) Min. Average Max.
New-Order 18.005/0.00 18.008/12.205 18.021/1250.266
Payment 3.010/0.00 3.018/12.014 3.031/1251.333
Order-Status 2.010/0.00 2.018/10.015 2.029/100.037
Delivery (interactive) 2.018/5.025 2.029/50.078
Stock-Level 2.010/0.00 2.018/5.015 2.030/50.082
Test Duration
Ramp -up time 80 minutes
Measurement interval 120 minutes
Transactions (all types) completed during measurement interval 13,761,271
Ramp down time 129 minutes
Checkpointing
Number of checkpoints 5
Checkpoint interval 23 minutes

HP Integrity rx2600 TPC Benchmark C ES.doc

General Items


Application Code and Definition Statements
The application program (as defined in clause 2.1.7) must be disclosed. This includes, but is not limited to, the code
implementing the five transactions and the terminal input output functions.

Appendix A contains all source code implemented in this benchmark.
Test Sponsor
A statement identifying the benchmark sponsor(s) and other participating companies must be provided.

This benchmark was sponsored by Hewlett Packard Company. The benchmark was developed and engineered by Hewlett Packard
Company and Oracle Corporation. Testing took place at HP Database Performance Engineering Laboratory in Houston, Texas.
Parameter Settings
Settings must be provided for all customer-tunable parameters and options which have been changed from the defaults found in
actual products, including by not limited to:
• Database options
• Recover/commit options
• Consistency locking options
• Operating system and application configuration parameters

This requirement can be satisfied by providing a full list of all parameters.

Appendix C contains the tunable parameters for the database, the operating system, and the transaction monitor.

Configuration Items
Diagrams of both measured and priced configurations must be provided, accompanied by a description of the differences.

The configuration diagram for both the tested and priced system are the same and included on the following page
7 HP Integrity rx2600 TPC Benchmark C FDR.doc
© 2004 Hewlett Packard Company. All rights reserved.

Un pour Un
Permettre à tous d'accéder à la lecture
Pour chaque accès à la bibliothèque, YouScribe donne un accès à une personne dans le besoin