Benchmark Reviews Discussion Forum Right Header

Go Back Benchmark Reviews Discussion Forum > Benchmark Reviews Forum > Member News

Member News Found something interesting? Share it here.

Reply
Thread Tools Display Modes
#1
Unread 3rd August 2009, 09:07 AM
Bruce Normann's Avatar
Bruce Normann Bruce Normann is offline
Senior Contributing Editor
Join Date: May 2008
Posts: 324
Business Sector Finally "Gets It" w/ SSDs

While other people were complaining about the high cost of SSDs and how they could only be justified for the most demanding database applications, someone decided to look at cost per transaction with an SSD-based system. Suddenly, "Faster = Cheaper", just like it's been for the last two decades in IT.

Interestingly, the server used a "regular" 15k RPM, 2.5" drive for the OS and applications. The SSDs were only used for data storage.
The www.tpc.org site has some very interesting benchmarks, all aimed at database performance.

SOURCE

Solid-State Storage Raises Bar For Database Performance
July 28, 2009

Fusion-io announced recently the first TPC-H benchmark test results leveraging solid-state storage (SSS) technologies. With off-the-shelf components from Dell, Fusion-io and Microsoft, the tested system achieved 28,772 QphH (Query-per-Hour Performance Metric) on a 100 gigabyte (GB) database, at a cost of only $1.47 per database transaction. The performance results and the total cost-of-ownership (TCO) savings for this complete system dramatically improved the price/performance ratio in database transactions using readily available, industry standard components. Savings from power usage, floor space and other infrastructure costs will lead to even greater reductions in data center TCO.

Unlike TPC-H benchmarks for traditional disks, the tested configuration from Dell, Fusion-io and Microsoft required very little tuning to achieve the performance of more than 160 hard disk drives. The system demonstrated that the raw power of solid-state technologies largely eliminates the need to spend IT energy tweaking and tuning to achieve optimum database performance.

"At a cost-per-transaction, inclusive of the server, software licensing and storage, the Fusion-io solution, which used solid-state technologies, reduced the cost of database transactions by almost half," said David Flynn, CTO, Fusion-io. "For a new storage technology using standard software and standard servers, these results are nothing short of astounding. Fusion-io's technology completely eliminates the need for exotic solutions, which typically are integrated at a substantially greater cost."

"These performance numbers showed that there are mainstream applications that can realize dramatic improvements in both price and performance by combining high-end, solid-state storage with the world's best industry-standard servers and software," said Paul Prince, CTO, Dell Enterprise Product Group. "In the past, high-performance SSDs were simply too cost-prohibitive to be taken seriously and these results confirmed that such configurations are a very real consideration for many applications in enterprise IT solutions."

"This configuration, which used off-the-shelf software from Microsoft and Fusion-io, takes database price/performance to a whole new level," said David Powell, director of performance for SQL Server at Microsoft Corp. "This test proved that solid-state technologies can now be used to reduce costs while providing unparalleled performance for the enterprise, in a system that's easy to configure and maintain."

Measurement Results:


System: Dell PowerEdge T610
Database Scale Factor 100 GB
TPC-H Power 38,550.7
TPC-H Throughput 21,475.1
TPC-H Composite Query-per-Hour Metric ([email protected]) 28,772.9
Total System Price Over Three Years $42,132
TPC-H Price Performance Metric ([email protected]) $1.46

These results were accomplished using a single Dell PowerEdge T610 server equipped with four Fusion-io 80GB ioDrives, running Microsoft Windows Server 2008 Enterprise Edition x64 and Microsoft SQL Server 2008 Enterprise Edition x64.

The complete results are available on the Transaction Processing Performance Council's Web site, at: http://www.tpc.org/tpch/results/tpch...p?id=109060201.

The TPC-H benchmark is described in more detail on the Web page: http://www.tpc.org/tpch/.

About Fusion-io


Fusion-io is a leading provider of enterprise solid-state technology and high-performance I/O solutions. The company's solid state storage technology closes the gap between processing power and traditional storage, delivering a new type of application centric storage for database, application and system administrators. The result is a world of possibilities for performance-starved applications. For more information, visit www.fusionio.com.

SOURCE: Fusion-io


System Specs
__________________
Men wanted for Hazardous Journey,
small wages, bitter cold,
long months of complete darkness,
constant danger, safe return journey doubtful.
Honour and recognition in case of success.

Ernest Shackleton
Reply With Quote
#2
Unread 3rd August 2009, 09:54 PM
Mathew Thompson Mathew Thompson is offline
Megabyte
Join Date: May 2008
Posts: 71
Quote:
Originally Posted by Bruce Normann View Post
Interestingly, the server used a "regular" 15k RPM, 2.5" drive for the OS and applications. The SSDs were only used for data storage.
When you're transferring files that are several gigabytes each, very fast data storage is paramount. The speed of the OS/application HDD is not nearly as important as the ability to move the raw data around. This is why video editing software works so much better when you have a scratch disk that is only for video files.
Reply With Quote
Sponsored links
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The perpetual "What's Next for Computer Hardware" thread... Olin Coles General Hardware Forum 8 28th June 2010 03:34 PM
"BIOSTAR TPOWER I55 - Intel LGA1156" ROCK windwithme Computer System Hardware 2 23rd July 2009 09:04 AM
"Cooling Motherboard Voltage Regulators - The Backside Approach" Article by Nick P. mike11 Computer System Hardware 2 13th March 2009 02:29 PM
Sendmail Error Solved: "550 Relaying denied." Olin Coles Web Design & Development 0 19th November 2008 02:04 PM
Intel Brings Quad SLI with the " Skulltrail " sushrukh Member News 0 24th September 2007 02:31 AM


All times are GMT -7. The time now is 10:28 PM.

Benchmark Reviews Discussion Forum
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Remove advertisements

Follow Benchmark Reviews on FacebookReceive Tweets from Benchmark Reviews on Twitter