Feeds

Nemesis looms over TPC-C benchmark

Expensive and oudated

Gartner critical capabilities for enterprise endpoint backup

TPC-C - that venerable server-come-database benchmark from the Transaction Performance Processing Council - looks set to be pensioned off at last with the recent announcement of a new OLTP (OnLine Transaction Processing) benchmark specification, TPC-E.

The new benchmark is aimed at moving the touchstone of database and server performance into the world of today rather than yesterday. This is being achieved by shifting the fundamental premise on which the specification is built to a model more fitting to current business needs.

TPC-C was built around a model of a typical database system needed to run a parts warehouse. With TPC-E the model has been shifted to a model of a typical brokerage operation. This should give a better simulation of the modern real-world transactions that take place over the Internet – including the time delays and fractures that can occur between distributed contributors to the smooth running of a transaction. In operation, the benchmark goes through the process of interacting with the financial markets to execute customer orders and update the relevant account information files.

The Council has also aimed at getting more reality into the benchmark by creating `real’ names, addresses and business details for the test database from data culled from US census and New York Stock Exchange information.

TPC-E is also scalable, so that the number of customers can be varied. This should expand the benchmark’s usefulness in allowing database and server vendors to pitch at small and mid-range market sectors specifically, and at a price that smaller vendors can afford. The price of conducting benchmark tests has been one of the recent criticisms of TPC-C, so much so that only the major vendors now attempt it.

One reason for this is the suggestion that results can be affected by factors such as the number of disk drives used, rather than the total disk capacity. So, more small capacity disks can mean a better test result. But it also means an impractical installation configured specifically for the test, sometimes with several thousand disk drives and a price tag running well into the millions. This is decreasingly relevant to the average business requirement, though the benchmark results are still seen as good guidance.

TPC-E is still currently in draft as Version 1.0.0 and more information, together with the detailed specification, can be found here. ®

Secure remote control for conventional and virtual desktops

More from The Register

next story
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Microsoft: Azure isn't ready for biz-critical apps … yet
Microsoft will move its own IT to the cloud to avoid $200m server bill
Oracle reveals 32-core, 10 BEEELLION-transistor SPARC M7
New chip scales to 1024 cores, 8192 threads 64 TB RAM, at speeds over 3.6GHz
US regulators OK sale of IBM's x86 server biz to Lenovo
Now all that remains is for gov't offices to ban the boxes
Object storage bods Exablox: RAID is dead, baby. RAID is dead
Bring your own disks to its object appliances
Nimble's latest mutants GORGE themselves on unlucky forerunners
Crossing Sandy Bridges without stopping for breath
A beheading in EMC's ViPR lair? Software's big cheese to advise CEO
Changes amid rivalry in the storage snake pit
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Top 10 endpoint backup mistakes
Avoid the ten endpoint backup mistakes to ensure that your critical corporate data is protected and end user productivity is improved.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Rethinking backup and recovery in the modern data center
Combining intelligence, operational analytics, and automation to enable efficient, data-driven IT organizations using the HP ABR approach.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.