Tuesday Oct 23, 2007
Ok there is a clear difference pointing to IBM's extensive marketing "spin" like we do here and IBM's sophomoric name-calling.
I hear IBM bloggers are commenting on the Sun Fire X4500's codename being "Thumper" and
trying to make it sound like a not serious data server - '"Thumper" is the cute rabbit'. Well IBM, it isn't the name of the server, the name is Sun Fire X4500, and it set two world records beating the best servers IBM has to offer. One result used IBM DB2 database, how cool is that!
Disclosure statement
IBM TPC-H 10000GB result on the IBM System p6 570 of 343,551.2 QphH@10000GB ($32.89usdd $/QphH@10000GB, avail. 4/15/2008) on a 32-node cluster of 4-core p570 (each with 2 POWER6 4.7 GHz processor chips, 4 cores, 8 threads) and 32GB of memory per node running DB2 Warehouse 9.5 on AIX 5L V5.3. Total disk capacity was 110,489.27 GB in a IBM Totalstorage DS4800 storage subsystem (using 36.4GB drives on 31 nodes and 73.4 GB drives on server 14) and 10Gigabit Ethernet for cluster interconnect. Source: http://www.tpc.org; Results current as of 10/15/07.
Sun Fire X4500 cluster 38,672.4 QphH@3000GB, $29.39 USD $/QphH@3000GB, Database: IBM DB2 Release 9.1, avail 10/12/07; IBM eServer xSeries 346 cluster 54,465.9 QphH@3000GB, 32.34 USD $/QphH@3000GB, avail 8/15/05. TPC-H, QphH, $/QphH tm of Transaction Processing Performance Council (TPC). More info www.tpc.org.
Wednesday Oct 17, 2007
The Sun Fire X4500 system running Solaris 10 and
Sybase IQ 12.6 achieved a new TPC-H Price/Performance World Record
of $8.11 USD $/QphH@1000GB. (Sun Fire X4500 was code-named "Thumper")
The single Sun Fire X4500 beat the previous best Price/Performance
result, the HP DL585 G2 16%, and is the only 2-socket submission at 1000GB
The total storage in this Sun configuration was 11.2TB and it still allowed it to set the price/performance record on this 1TB Benchmarks (1TB ~= SF1000 = 1000GB). Lowest total cost of ownership ($45,439) of ANY submission at
1000GB and less than 1/3rd of the cost of the HP DL585 G2 total configuration.
The TPC-H result demonstrates the Sun Fire X4500 capabilities as
a database machine. Each node of the X4500 cluster delivered 1.5
GB/sec of real IO throughput for a total of 1.5 GB/sec.
The TPC-H result demonstrates the effectiveness of Solaris 10
running Sybase IQ and results on the Opteron processors.
Another "warehouse in a box" result from Sun. To date, Sun is the only
vendor to be able to produce "in the box" TPC-H results of any kind.
TPC-H @1000GB Performance Chart (to be added, sorry it is very late right now)
QphH = the Composite Metric (bigger is better)
$/QphH = the Price/Performance metric (smaller is better)
QppH = the Power Numerical Quantity
QthH = the Throughput Numerical Quantity
| System |
Sockets/
Cores/
Threads |
CPU Type |
GHz |
QphH |
Price/
QphH
|
Price
in
currency
|
DBMS
|
Available |
Disk
Data
Ratio
|
Sun Fire X4500
|
2/4/4
|
Opteron
|
2.8
|
5604
|
8.11
|
45,439 $US
|
SybIQ
|
10/15/07 |
11.2 |
HP DL585 G2
|
4/8/8
|
Opteron
|
2.8
|
14773
|
9.73
|
143,736 $US
|
SQLS
|
04/25/07 |
7.8 |
Bull 3045
|
4/8/16 |
Itanium
|
1.6
|
12087
|
12.56
|
151,870 $US
|
SQLS
|
03/06/07
|
5.7 |
HP DL585 G1
|
4/4/4 |
Opteron
|
2.4
|
10493
|
13.85
|
145,264 $US
|
SQLS
|
03/02/06
|
6.4 |
Bull 5651
|
16/16/16 |
Itanium
|
1.6
|
17060
|
25.48
|
434,553 $US
|
SQLS
|
05/08/06
|
9.3 |
Sun Fire V490
|
4/8/8 |
US-IV+
|
1.5
|
4368
|
31.17
|
136,121 $US
|
SybIQ
|
01/05/06
|
2.7 |
Details of the Sun X4500 test
Complete benchmark results may be found at the TPC benchmark website http://www.tpc.org.
Benchmark Description
The TPC-H benchmark is a performance benchmark established by the
Transaction Processing Council (TPC) to demonstrate Data
Warehousing/Decision Support Systems (DSS). TPC-H measurements are
produced for customers to evaluate the performance of various DSS
systems. These queries and updates are executed against a standard
database under controlled conditions. Performance projections and
comparisons between different TPC-H Database sizes (100GB, 300GB,
1000GB, 3000GB and 10000GB) are not allowed by the TPC.
TPC-H is a data warehousing-oriented, non-industry-specific benchmark
that consists of a large number of complex queries typical of decision
support applications. It also includes some insert and delete activity
that is intended to simulate loading and purging data from a warehouse.
TPC-H measures the combined performance of a particular database
manager on a specific computer system.
The main performance metric reported by TPC-H is called the TPC-H
Composite Query-per-Hour Performance Metric (QphH@SF, where SF is the
number of GB of raw data, referred to as the scale factor). QphH@SF is
intended to summarize the ability of the system to process queries in
both single and multi user modes. The benchmark requires reporting of
price/performance, which is the ratio of QphH to total HW/SW cost plus
3 years maintenance. A secondary metric is the storage efficiency,
which is the ratio of total configured disk space in GB to the scale
factor.
Disclosure Statement:
Sun Fire X4500 5,604.9 QphH@1000GB, $8.11 USD $/QphH@1000GB, avail
10/15/07; HP DL585 G2, 14,773 QphH@1000GB, $9.73 USD $/QphH@1000GB, avail
4/25/07; TPC-H, QphH, $/QphH tm of Transaction Processing
Performance Council (TPC). More info www.tpc.org.
Results Summary SF1000 (SF1000 = 1000GB) benchmark
| Audited Results |
| |
Database Size: |
1000 GB (Scale Factor 1000) |
| |
TPC-H Composite: |
5,604.9 QphH@1000GB |
| |
Price/performance: |
$8.11 USD $/QphH@1000GB |
| |
Available: |
October 15, 2007 |
| Number of Systems: |
one Sun Fire X4500 |
| Total Number Processors: |
2 |
| Processor/MHz of Server: |
AMD Dual Core Opteron Model 290 2.8 GHz |
| Storage: |
11.18 Terabytes of disk |
| Database: |
Sybase IQ 12.6 |
| Operating System: |
Solaris 10 |
| Total 3 year Cost: |
$45,439.50 USD |
| Other Performance Metrics |
| |
TPC-H Power: |
6,446.1 |
| |
TPC-H Throughput: |
4,873.5 |
| |
Database Load Time: |
10 hours 5 minutes |
Wednesday Oct 17, 2007
The 10-node Sun Fire X4500 cluster running Solaris 10 and
IBM DB2 9.1 achieved a new TPC-H Price/Performance World Record
of $29.39 USD $/QphH@3000GB. (Sun Fire X4500 was code-named "Thumper")
The Sun Fire X4500 cluster beat the previous best Price/Performance
result, the IBM xSeries 346 cluster by 9%.
The total storage in this Sun configuration was 218TB and it still allowed it to set the price/performance record on this 3TB Benchmarks (3TB ~= SF3000 = 3000GB).
With this result, Sun systems running Solaris 10 now hold 2 of the top
4 price/performance results on the TPC-H@3000GB benchmark and 3 of the top 10.
The TPC-H result demonstrates the Sun Fire X4500 capabilities as
a database machine. Each node of the X4500 cluster delivered 1.5
GB/sec of real IO throughput for a total of 15 GB/sec.
The TPC-H result demonstrates the effectiveness of Solaris 10
running DB2 and results on the Opteron processors.
TPC-H @3000GB Performance Chart
QphH = the Composite Metric (bigger is better)
$/QphH = the Price/Performance metric (smaller is better)
QppH = the Power Numerical Quantity
QthH = the Throughput Numerical Quantity
| System |
Composite
(QphH) |
3 Year Total
System Cost |
$/perf
$/QphH |
Power
(QppH) |
Through-
put (QthH) |
Proc |
Storage
Amount |
| Sun Fire X4500 |
38,672.4 |
$1,136,536 |
$29.39 |
51,320.0 |
29,141.8 |
20 |
218.3 TB |
| IBM xSeries 346 |
54,465.9 |
$1,761,686 |
$32.34 |
90,854.7 |
32,651.4 |
64 |
25.6 TB |
| HP Superdome |
60,359.3 |
$1,967,970 |
$32.60 |
80,838.3 |
45,068.3 |
32 |
32.9 TB |
| Sun Fire E25K |
114,713.7 |
$4,207,126 |
$36.68 |
136,798.4 |
96,194.3 |
72 |
63.3 TB |
| HP Proliant BL25p |
110,576.5 |
$4,179,238 |
$37.80 |
116,379.3 |
105,063.0 |
64 |
69.6 TB |
| Unisys ES7000/one |
30,013.4 |
$1,135,354 |
$37.83 |
38,395.9 |
23,460.9 |
16 |
27.8 TB |
| HP rx8640 |
37,813.7 |
$1,433,521 |
$37.92 |
51,160.6 |
27,948.8 |
16 |
22.6 TB |
| Unisys ES7000 Orion |
26,246.1 |
$1,169,880 |
$44.58 |
33,415.8 |
20,614.7 |
32 |
23.8 TB |
| IBM p595 |
100,512.3 |
$5,358,874 |
$53.32 |
132,598.2 |
76,190.5 |
64 |
37.7 TB |
| Sun Fire E25K |
105,430.9 |
$5,784,902 |
$54.87 |
121,805.8 |
91,257.4 |
72 |
94.8 TB |
| HP Superdome |
71,847.8 |
$4,008,065 |
$55.79 |
92,335.6 |
55,905.9 |
64 |
40.6 TB |
| System |
Proc |
cluster |
CPU
MHz |
Type |
Operating System |
Database |
RDBMS+HW
Available |
| Sun Fire X4500 |
20 |
Y |
2600 |
AMD Opteron
285 |
Solaris 10 |
DB2 9.1 |
10/12/2007 |
| IBM xSeries 346 |
64 |
Y |
3600 |
Intel Xeon |
Suse Linux |
DB2 UDB 8.2 |
08/15/2005 |
HP Integrity
Superdome |
32 |
N |
1600 |
Itanium2 |
Windows 2003 |
Microsoft SQL
Server |
05/21/2007 |
| Sun Fire E25K |
72 |
N |
1800 |
UltraSPARC IV+ |
Solaris 10 |
Oracle 10g |
04/09/2007 |
| HP ProLiant BL25p |
64 |
Y |
2600 |
AMD Opteron 285 |
Red Hat Enter. Linux 4 |
Oracle 10g |
06/08/2006 |
| Unisys ES7000/one |
16 |
N |
1600 |
Itanium2 |
Windows 2003 |
Microsoft SQL
Server |
09/08/2006 |
| HP rx8640 |
16 |
N |
1600 |
Itanium2 |
Windows 2003 |
Oracle 10g |
05/14/2007 |
| Unisys ES7000 Orion |
32 |
N |
1600 |
Itanium2 |
Windows 2003 |
Microsoft SQL
Server |
05/05/2006 |
| IBM p595 |
64 |
N |
1900 |
POWER 5 |
AIX 5L V5.3 |
Oracle 10g |
03/01/2006 |
| Sun Fire E25K |
72 |
N |
1500 |
UltraSPARC IV+ |
Solaris 10 |
Oracle 10g |
01/27/2006 |
| HP Superdome |
64 |
N |
1600 |
Itanium2 |
HP-UX 11.i V2 |
Oracle 10g |
01/18/2006 |
Complete benchmark results may be found at the TPC benchmark website http://www.tpc.org.
Benchmark Description
The TPC-H benchmark is a performance benchmark established by the
Transaction Processing Council (TPC) to demonstrate Data
Warehousing/Decision Support Systems (DSS). TPC-H measurements are
produced for customers to evaluate the performance of various DSS
systems. These queries and updates are executed against a standard
database under controlled conditions. Performance projections and
comparisons between different TPC-H Database sizes (100GB, 300GB,
1000GB, 3000GB and 10000GB) are not allowed by the TPC.
TPC-H is a data warehousing-oriented, non-industry-specific benchmark
that consists of a large number of complex queries typical of decision
support applications. It also includes some insert and delete activity
that is intended to simulate loading and purging data from a warehouse.
TPC-H measures the combined performance of a particular database
manager on a specific computer system.
The main performance metric reported by TPC-H is called the TPC-H
Composite Query-per-Hour Performance Metric (QphH@SF, where SF is the
number of GB of raw data, referred to as the scale factor). QphH@SF is
intended to summarize the ability of the system to process queries in
both single and multi user modes. The benchmark requires reporting of
price/performance, which is the ratio of QphH to total HW/SW cost plus
3 years maintenance. A secondary metric is the storage efficiency,
which is the ratio of total configured disk space in GB to the scale
factor.
Disclosure Statement:
Sun Fire X4500 cluster 38,672.4 QphH@3000GB, $29.39 USD $/QphH@3000GB, avail
10/12/07; IBM eServer xSeries 346 cluster 54,465.9 QphH@3000GB, 32.34 USD
$/QphH@3000GB, avail 8/15/05. TPC-H, QphH, $/QphH tm of Transaction Processing
Performance Council (TPC). More info www.tpc.org.
Results Summary SF3000 (SF3000 = 3000GB) benchmark
| Audited Results |
| |
Database Size: |
3000 GB (Scale Factor 3000) |
| |
TPC-H Composite: |
38,672.4 QphH@3000GB |
| |
Price/performance: |
$29.39 USD $/QphH@3000GB |
| |
Available: |
October 12, 2007 |
| Number of Systems: |
10 Sun Fire X4500 |
| Total Number Processors: |
20 |
| Processor/MHz of Server: |
AMD Dual Core Opteron Model 285 2.6 GHz |
| Storage: |
218.3 Terabytes of disk |
| Database: |
DB2 Release 9.1 |
| Operating System: |
Solaris 10 |
| Total 3 year Cost: |
$1,136,536 USD |
| Other Performance Metrics |
| |
TPC-H Power: |
51,320.0 |
| |
TPC-H Throughput: |
29,141.8 |
| |
Database Load Time: |
3 hours 39 minutes |
Wednesday Jun 13, 2007
InfoWorld has published a very positive review of the Sun Fire x4500 server. The combination X4500 running Solaris 10 with Sun's ZFS scored an great 8.8 rating with "Excellent" recommendation.
Paul Venezia, author/reviewer, started with a description X4500 (code name "Thumper"), highlighting it design and unprecedented hard drive capactiy.
He evaluated x4500 running Solaris -- mentioning that other OSes simply did not have the file system capabilities to take full advantage of the huge number
of X4500's drives.
Paul writes: "ZFS and the X4500 go hand in hand, seemingly created for each other in a love story rivaling anything that’s come out of Hollywood in the past 10 years."
"Thumper is aptly named and is a truly unique product from a company that seems to be pulling away from a faltering reputation in the server market. Recent studies have shown that within a few short years, the world will generate more data than it can store. It would seem that Sun is doing its part to bridge that gap."
Read all about it at the full link:
www.infoworld.com/infoworld/article/07/06/07/23TCthumper_1.html
|
|
|
|
I am reminded of a peanuts cartoon, with Lucy expo...
Beating?
54,465/38,672=40% slower than ...