1 / 10

TPC Announces First Results for its TPC-Energy Specification

TPC Announces First Results for its TPC-Energy Specification. Group 25 Sumin Mohanan, Zoheb .H Borbora 3/8/2011. Background. TPC (Transaction Processing Performance Council) Founded in 1988 to define transaction processing and database benchmarks Obsolete standards

claire
Download Presentation

TPC Announces First Results for its TPC-Energy Specification

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TPC Announces First Results for its TPC-Energy Specification Group 25 Sumin Mohanan, Zoheb .H Borbora 3/8/2011

  2. Background • TPC (Transaction Processing Performance Council) • Founded in 1988 to define transaction processing and database benchmarks • Obsolete standards • TPC-A : update – intensive database environments • TPC-App : Application server and web services benchmark • TPC – B : Measured throughput as transactions / second • TPC- D : Decision support applications (long running queries) • TPC – R : Business reporting / Decision support benchmark • TPC – W : Transactional web e-commerce bench mark • Current standards • TPC- C : OLTP benchmark • TPC- E : OLTP benchmark that simulates the workload of a brokerage firm • TPC – H : Ad hoc decision support benchmark • Add-ons • TPC- PR : A single pricing specification to be consistent across benchmarks • TPC- Energy : Augments TPC Benchmarks with Energy Metrics

  3. Why concerned with Energy ? • As of 2006, electricity used by servers and data centers in USA is equal to the amount of electricity used by the entire U.S transportation manufacturing industry (US Census Bureau 2006, US DOE 2005) • In 2006, More than one-third of the electricity use in USA IT space attributable to enterprise-class data centers. http://www.energystar.gov/ia/partners/prod_development/downloads/EPA_Datacenter_Report_Congress_Final1.pdf

  4. Energy cost is significant.. Ref :Energy Cost , The Key Challenge of Today's Data Centers : A power consumption analysis of TPC-C Results , ACM 2008

  5. Breakdownof data center energy overhead • Much of this poor efficiency is caused by a historical lack of attention to power efficiency not by inherent limitations imposed by physics Ref : L. A. Barroso, U. Hölzle, The Datacenter as a Computer:An Introduction to the Design of Warehouse-Scale Machines, 2009

  6. TPC – Energy • TPC, SPEC, SPC • Prominent industry consortia for performance measurements • 2007 - TPC formed a committee to add energy metrics to all its benchmarks • Wherein TPC performance metrics correspond to the amount of work completed per unit of time, TPC - Energy metric measures the energy consumption corresponding to the amount of work • Metric plainly represented as Watts/Performance Ref: http://www.tpc.org/tpc_energy/Presentations/EnergyBenchmarks.pdf

  7. TPC – Energy • Comprehensive metric that takes into account • all the components including database server, middle tier, storage subsystem and connectivity devices • Work load characteristics (time based vs task based) • Overall power • Pi = Power consumption in interval i • Ti = Performance measurement (tpmC, tpsC) in interval i • Si = weight corresponding to duration of the interval i

  8. Energy vs performance trade-off • Performance comparison for the TPC-E benchmark with and without energy metric • Best Watts/tpsE results – 0.93 • Fujitsu Primergy RX300* – results submitted 2/14/11 • Great improvement over the HP Proliant system (Watts/tpsE = 5.84) Ref: http://www.tpc.org/tpce/default.asp

  9. Energy Saving Ideas • Data center best practices • Measure Power Usage Effectiveness (PUE) • Manage air flow • Adjust the thermostat. • Use free cooling. • Optimize power distribution. • Buy efficient servers. • Warehouse-scale computer • Holistic approach to the design and development of various components of the modern data center Ref: http://www.google.com/corporate/datacenter/best-practices.html

  10. References • http://www.tpc.org/information/press/tpcpress20100707.asp • Energy Cost , The Key Challenge of Today's Data Centers : A power consumption analysis of TPC-C Results , Poess et al., ACM 2008 • www.energystar.gov/ia/partners/prod_development/downloads/EPA_Datacenter_Report_Congress_Final1.pdf • http://www.tpc.org/tpc_energy/Presentations/EnergyBenchmarks.pdf • http://en.wikipedia.org/wiki/Transaction_Processing_Performance_Council • http://www.tpc.org/tpce/default.asp • http://www.google.com/corporate/datacenter/best-practices.html • L. A. Barroso, U. Hölzle, The Datacenter as a Computer:An Introduction to the Design of Warehouse-Scale Machines, 2009

More Related