tpc benchmarks
DESCRIPTION
TPC Benchmarks. Sandeep Gonsalves CSE 8330 – Project 1 SMU May 1, 2004. Overview. Benchmarks Benchmark Wars Establishment of the TPC TPC Benchmarks: A, B, C, D, E, H, R, S, W Conclusion. Benchmarks. Standard for comparison of various systems performing similar operations - PowerPoint PPT PresentationTRANSCRIPT
TPC Benchmarks
Sandeep GonsalvesCSE 8330 – Project 1
SMU
May 1, 2004
Overview
Benchmarks Benchmark Wars Establishment of the TPC TPC Benchmarks: A, B, C, D, E, H, R,
S, W Conclusion
Benchmarks
Standard for comparison of various systems performing similar operations
Set of programs that simulate a typical workload on a given system
Used to measure system performance Metrics such as speed, performance,
price etc. are recorded Used to determine the optimal system
Domain-specific benchmarks
“No single metric can measure the performance of computer systems on all applications” [1]
Performance of a system varies tremendously from one application domain to another [1]
Domain-specific benchmarks
Key criteria for a domain-specific benchmark to be useful: Relevant Portable Scaleable Simple [1]
Early Benchmarks
TP1 benchmark Wisconsin benchmark
Benchmark Wars
Benchmark wars happen when one vendor publishes superior results for an important benchmark evaluation and the other vendors or individuals try to get back by improving their numbers [2]
Consequences: Abnormal results Waste of resources Confusion !
Initial Efforts
Working Group on Performance Measurement Standards (WG-PMS) [2]
Anon et.al. 1985 Three standard performance tests
for OLTP systems Most popular – DebitCredit [2]
Establishment of the TPC
Motivation: Need for the competition to get
civilized Put an end to manipulations Stop the confusion in the industry Form an industry forum to enforce
OLTP performance measurement standards [2]
TPC
TPC is the acronym for the Transaction Processing Performance Council
Established on 10th August, 1988 Founder: Omri Serlin Co-founder: Tom Sawyer Initial 8 members: Control Data Corp,
Digital Equipment Corp, ICL, Pyramid Technology, Stratus Computer, Sybase, Tandem Computers and Wang Laboratories [2]
TPC
First standard TPC-A published in November, 1989
TPC-A – Council’s version of the DebitCredit benchmark test [2]
Published the second standard TPC-B in August 1990
TPC-B – Council’s version of the TP1 benchmark test [2]
TPC
Major changes brought about by the TPC: [2]
Submission of a Full Disclosure Report (FDR)
Results must be audited by a TPC certified individual
TPC Members - 2004
TPC Auditors - 2004
TPC Benchmark ™ A Issued in November 1989 Obsolete as of 6th June, 1995 Measure performance of update-
intensive database environments [5]
e.g.. OLTP applications with characteristics like: “Multiple on-line terminal sessions Significant disk input/output Moderate system and application execution time Transaction integrity” [5]
TPC Benchmark ™ A Measures the transactions per second (tps) of
a system as a measurement of performance [5]
Measure the performance of systems in a wide area or local area network configuration [5]
Metrics are: “TPC-A local Throughput” and “TPC-A wide Throughput” measured in tps [6]
System configurations, details of the benchmark run, total cost mandatory part of FDR [6]
TPC-A Specifications [5]
Specification consists of 11 clauses TPC-A is stated in terms of a hypothetical
bank that has one or more branches and each branch has multiple tellers
Each customer of the bank has an account Transactions denote customer operations
such as withdrawals, deposits etc. performed by a teller at a branch
TPC-A Specifications
Fig 4: ER Diagram of the components of the TPC Benchmark™ A database [5]
TPC-A Specifications [5]
Any commercially available database management system (DBMS), database server, file system, etc can be used to implement the database
The system under test must support the ACID properties of transaction processing systems
Horizontal partitioning of files/tables is permitted
Vertical partitioning of files/tables is not permitted
TPC-A Results [5]
Throughput of the system in units of transactions per second is: “tpsA-Local” - local area networks “tpsA-Wide” - wide area networks
Cost is given as price/tpsA “ what is tested and/or emulated is priced
and what is priced is tested and/or emulated ”
5 year maintenance pricing must be included
TPC-A FDR Requirements [5]
Identification of sponsor of the benchmark Participating companies Program listings List of settings for parameters and
options that are tunable by a customer and have been altered from the defaults in actual products
Auditor’s name, address, phone number along with a copy of the auditor’s attestation letter
Etc…
TPC-A FDR Requirements [5]
In short:All that a customer would need to replicate the results !
The FDR document must be available to the public at a reasonable cost
Official language is English
TPC Benchmark ™ B
Approved in August 1990 Obsolete as of 6th June, 1995 Quite different from TPC-A Database Stress Test Not OLTP oriented It focuses on database management
systems (DBMS) applications and on the back-end database server [8]
TPC-B Specifications [8]
Specified in terms of a hypothetical bank Measures the total number of
simultaneous transactions that a system can carry out
No users, communication lines or terminals used
Equivalent to electronic data processing (EDP) batch processing applications
Metrics –Throughput: “tpsB” and the associated price-per-TPS
TPC Benchmark ™ C
Approved on July 23, 1992 Currently in use with its latest version 5.2 It is an OLTP benchmark It is centered on the transactions of a
wholesale supplier managing orders which is an order-entry environment [14]
TPC-C metrics are new-order txn rate (tpmC) and price/performance ($/tpmC) [14]
TPC Benchmark ™ C
It measures the entire business operation and is a more extensive and complex yardstick for measuring the performance of an OLTP system [14]
Current version is the 20th revision since 1992 [12]
TPC Benchmark ™ D
Approved on April 5, 1995 Obsolete as of April 6, 1999 Decision support benchmark Metrics are:
TPC-D Composite Query-per-Hour Metric (QphD@Size)
TPC-D Price/Performance ($/QphD@Size)
Systems Availability Date [18]
TPC Benchmark ™ D
“It illustrates decision support systems that: Examine large volumes of data; Execute queries with a high degree of
complexity; Give answers to critical, frequently-asked
business questions [18] ”
It’s successors are TPC-H and TPC-R
TPC Benchmark ™ H
Approved on February 26, 1999 Current version is 2.1.0 which was
specified on August 14, 2003 Decision support benchmark It executes a set of queries against a
standard database under controlled conditions to evaluate the performance of various decision support systems [20]
TPC Benchmark ™ H
Metrics are: TPC-H Composite Query-per-Hour Metric
(QphH@Size) which is the performance metric
TPC-H Price/Performance ($/QphH) which is the price-performance metric
The Systems Availability Date [20]
TPC Benchmark ™ R
Approved on February 26, 1999 Current version is 2.1.0 which was
specified on August 14, 2003 Decision support benchmark Similar to TPC-H
TPC Benchmark ™ R
The TPC-R metrics are: TPC-R Composite Query-per-Hour
Metric (QphR@Size) which is the performance metric
TPC-R Price/Performance ($/QphR) which is the price-performance metric
System Availability date [23]
TPC Benchmark ™ W
TPC’s latest benchmark First version 1.0 was approved on
December 9, 1999 Transactional web e-Commerce
benchmark that models a retail store on the internet like an online bookstore. [24]
TPC-W enables the testing of environments where a host of servers perform different functions [25]
TPC Benchmark ™ W TPC-W metrics are:
Number of web interactions processed per second (WIPS) which is the performance metric.
The associated price per WIPS ($/WIPS) The availability date of the priced
configuration [26]
It can verify the performance measurements of a variety of e-commerce servers in a real world internet environment [25]
Aborted benchmark efforts
TPC – S Server version of the TPC-C Did not receive sufficient Council
support Potential for abnormally high
performance ratings [22]
Aborted benchmark efforts TPC – E
“Enterprise” benchmark No complex benchmark available that
could stress large enterprise systems Could cause confusion Would cause vendors to spend
additional resources Was germane to only a very small
number of vendors competing in that arena [22]
What's up with the TPC
As of March 2004: Working on a new TPC-E
specification Working on a new decision support
benchmark: TPC-DS Carrying out revisions on the TPC-
H, TPC-R, TPC-W
Conclusion - TPC
Fair-competition in the industry End to bench marketing wars Widely used by all vendors Continuous evolution of its
benchmarks
Conclusion - TPC Log
References [1] Jim Gray: Database and Transaction Processing
Performance Handbook. The Benchmark Handbook 1993. Online edition. http://www.benchmarkresources.com/handbook/index.html
[2] Omri Serlin: The History of DebitCredit and the TPC. The Benchmark Handbook 1993. Online edition.
http://www.benchmarkresources.com/handbook/index.html
[3] Anon, et al, “A Measure of Transaction Processing Power”, Datamation, V. 31.7, April 1985, pp. 112-118.
[4] Gray, J.N., Reuter, A., “Transaction Processing: Concepts and Techniques, Morgan Kaufmann, San Mateo, CA, 1993, pp. 11-12, 168.
References [5] TPC BENCHMARK™ A Standard
Specification Revision 2.0 7June 1994 http://www.tpc.org/tpca/spec/tpca_current.pdf
[6] TPC-Ahttp://www.tpc.org/tpca/default.asp
[7] Hanson, Robert J., TPC Benchmark B - What It Means and How to Use It, AT&T Global Information Solutionshttp://www.tpc.org/tpcb/default.asp
[8] TPC BENCHMARK™ B Standard Specification Revision 2.0 7June 1994 http://www.tpc.org/tpcb/spec/tpcb_current.pdf
References [9] Bramer, Brian. System benchmarks,
DeMontfort University, UK. http://www.cse.dmu.ac.uk/~bb/Teaching/ComputerSystems/SystemBenchmarks/BenchMarks.html#introduction
[10] Levine, Charles.,SIGMOD '97 Industrial Session 5 - 5/29/97. http://www.tpc.org/information/sessions/sigmod/indexc.htm
[11] Ozsu, T., P. Valderez’s, Principles of Distributed Database Systems, Second Edition. Prentice Hall, Englewood Cliffs, NJ., 1999.
[12] TPC BENCHMARK™ C Standard Specification Revision 5.2 December 2003 http://www.tpc.org/tpcc/spec/tpcc_current.pdf
References
[13] Patterson, D. A., J. L. Hennessy, Computer Architecture, a Quantitative Approach, Morgan Kaufmann, San Mateo, CA, 1990. Chapter 1.
[14] Raab, Francois et.al. Overview of the TPC Benchmark C: The Order-Entry Benchmark.http://www.tpc.org/tpcc/detail.asp
[15] TPC-C http://www.tpc.org/tpcc/default.asp
[16] TPC-Dhttp://www.tpc.org/tpcd/default.asp
References [17] Stephens, Jack. TPC-D. The Industry
Standard Decision Support Benchmarkhttp://www.tpc.org/information/sessions/sigmod/indexc.htm
[18] TPC BENCHMARKTM D (Decision Support) Standard Specification Revision 2.1http://www.tpc.org/tpcd/spec/tpcd_current.pdf
[19] TPC-Dhttp://www.tpc.org/tpcd/default.asp
[20] TPC BENCHMARK™ H (Decision Support) Standard Specification Revision 2.1.0http://www.tpc.org/tpch/spec/tpch2.1.0.pdf
References [21] Levine, Charles. TPC Benchmarks, Microsoft.
http://research.microsoft.com/~gray/WICS_96_TP/
[22] Draft White Paper. August 2, 1999. Object Management Group www.omg.org/docs/bench/99-08-02.ps
[23] TPC-Rhttp://www.tpc.org/tpcr/default.asp
[24] TPC Benchmark™ W (Web Commerce) SpecificationVersion 1.8. Feb 19, 2002.http://www.tpc.org/tpcw/spec/tpcw_V1.8.pdf
References
[25] Smith, Wayne D. TPC-W*: Benchmarking: An Ecommerce Solution. Revision 1.2. Intel Corporation.http://www.tpc.org/tpcw/TPC-W_wh.pdf