ZDNet UK


Skip to Main Content

ZDNet.co.uk - Winner of Best Business Website 2007
  1. Home
  2. News
  3. Blogs
  4. Reviews
  5. Prices
  6. Resources
  7. Community
  8. My ZDNet

 

ZDNet UK RSS Feeds


IT Jobs

Databases Toolkit

Servers get new database speed test

Stephen Shankland CNET News.com

Published: 19 Mar 2007 10:30 GMT

  • Email
  • Trackback
  • Clip Link
  • Print friendly
  • Post Comment

After 14 years measuring the world's most powerful servers, the TPC-C speed test is being supplanted by a new benchmark.

The Transaction Processing Performance Council has approved the new standard, called TPC-E, which is designed to be easier and less expensive to run and to be more representative of what databases are used for these days. The first results of the test should begin arriving this summer, once auditors are trained to make sure computer makers know and adhere to test guidelines.

TPC-E simulates traders and brokers interacting with a stock exchange. Information is stored in 33 separate database tables, with actions in one area often triggering actions in another. In comparison, TPC-C dealt with simpler data and operations stored in nine tables that simulated inventory management at a warehouse.

There's no such thing as benchmarks that measure all aspects of a computer's performance, but they still can be a useful way to compare different companies' products. TPC-C was widely used for this task — but servers and databases have changed a lot since its debut in July 1992.

"TPC-C is at the end of its life. It's time for a new benchmark," said Andreas Hotea, who leads the effort to publicise TPC-E. The council, whose members include all the major server and database companies, spent five years creating the benchmark, said TPC administrator Michael Majdalany.

One problem with TPC-C is that high scores require an inordinate amount of storage — not just raw capacity, but numerous hard drives. IBM's and Hewlett-Packard's top TPC-C scores each used more than 7,000 hard drives, Majdalany said. TPC-E will probably need only a tenth of that capacity, he said.

It's typical for a TPC-C test to cost $4m (£2m) to run, Hotea said, mostly through hardware costs. An IBM machine tested in 2006 and currently No. 2 in the TPC-C rankings with a score of 4.03 million transactions per minute cost $12m. HP topped that score with 4.09 million transactions per minute with another $12m machine.

With TPC-C, Majdalany said, "only rich companies can do it".

The new test will be cheaper to run partly because hardware demands are more reasonable, but also because TPC will supply source code for the software instead of requiring testers to write their own, Hotea said.

  • Email
  • Trackback
  • Clip Link
  • Print friendly Print with Dell

Did you find this article useful?


Full Talkback thread

0 comments

Company/Topic Alerts

Create a new alert from the list below:







Related Jobs

SAP DATA ARCHIVER

The contractor will implement SAP archiving solution by enabling the archiving technical infrastructure, archiving objects, perform extensive testing ...

SQL Server Developer - Data warehousing skills wanted

SQL Server Developer - SQL Server 2005, replication, large scale databases, T-SQL, complex stored procedures Required for a market leading technology ...

SAS Data Warehouse Analyst, upto 35,000 +package, West Yorkshire

Day to day responsibilities will include developing and maintaining complex reports, tables and warehouse structures to satisfy business requirements ...

Featured Talkback

How can it be true that doing the work of gathering and concentrating information about a person and placing it in a single database with multiple access routes; makes that information more secure?! I would suggest that most people would make the implicit assumption that that would make it *less* secure.

By: Andrew Meredith

Read full story:
Police chief criticises ID cards scheme

Discussions

keithmv keithmv

Password Deadlock

Saturday 26 July 2008, 12:02 PM

2 comments