[PDF]Executive Summary - Rackcdn.comc970058.r58.cf2.rackcdn.com/individual...
3 downloads
235 Views
642KB Size
Lenovo ThinkServer RD630 Total System Cost
TPC-H Rev. 2.15.0 TPC-Pricing Rev. 1.7.0 Report Date: May 10, 2013
Composite Query per Hour Metric
Price / Performance
434,353.2
$0.24 USD
$103,774 USD
QphH@300GB
Database Size
Database Manager
Operating System
300GB
VectorWise 3.0.0
RedHat Enterprise Linux 6.4
$ / QphH@300GB
Other Software
Availability Date
May 10, 2013
2.1 15.9
RF2 RF1 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 25 50 75 Database Load Time = 4:04:26 Load Includes Backup: N Total Data Storage / Database Size = 8.00 Percentage Memory / Database Size = 42.67% System Configuration: Memory: Disk Controller Storage: Total Storage: LAN Controller
TPC-H Executive Summary © 2013 Lenovo Corp. All rights reserved
Geomean _______ 2.1 Arithmetic Mean -------15.9
Throughput Power
100
125 150 175 Storage Redundancy Level Base Tables and Auxiliary Data Structures DBMS Temporary Space OS and DBMS Software Lenovo ThinkServer RD630 128 GB ThinkServer RAID 700 controller 8 x 300GB 10K RPM HDD 2400 GB Onboard dual port 1G NIC
5 5 0
i
T TPC-H Executive e Summary © 2013 Lenovo Corp. C All rights re eserved
ii
T TPC-H Executive e Summary © 2013 Lenovo Corp. C All rights re eserved
iii
Stream ID 0 1 2 3 4 5 6 M Minimum M Maximu A Average
Q1 3 3.8 20 0.6 20 0.6 15 5.7 17 7.3 30 0.3 20 0.0 3 3.8 30 0.3 18 8.3
Q2 0.7 5.9 2.2 6.2 2.9 2.4 2.9 0.7 6.2 3.3
Q3 0.6 1.6 1.1 0.9 1.0 1.8 2.0 0.6 2.0 1.3
Q4 Q 0.2 0.9 0.7 1.3 1.2 1.2 0.9 0.2 1.3 0.9
Q5 1.4 4 5.4 4 3.9 9 8.4 4 5.8 8 7.7 7 8.5 5 1.4 4 8.5 5 5.9 9
Q6 0.2 1.5 1.1 1.3 1.4 1.5 0.7 0.2 1.5 1.1
Q7 1.4 9.3 18.6 13.9 5.3 8.7 6.7 1.4 18.6 9.1
Q8 1 .9 6 6.7 12 2.0 18 8.8 12 2.3 12 2.9 8 8.6 1 .9 8.8 18 10 0.5
Q9 11.7 64.5 93.8 182.6 95.7 84.2 49.3 11.7 182.6 83.1
Q10 5.2 15.1 15.7 15.8 13.4 15.7 22.9 5.2 22.9 14.8
Q1 11 0.9 6.3 2.7 4.2 6.4 2.8 2.1 0.9 6.4 3.6
Q12 0.8 3.0 2.7 2.6 5.6 6.8 3.9 0.8 6.8 3.6
Stream 3 ID Q13 0 11 1.4 1 70 0.9 2 31 1.9 3 21 1.7 4 65 5.6 5 71 1.0 6 54 4.8 M Minimum 11 1.4 M Maximu 71 1.0 A Average 46 6.8
Q14 1.7 6.8 9.5 7.7 11.4 11.2 5.4 1.7 11.4 7.7
Q15 0.8 8.4 3.3 2.1 3.6 1.8 3.4 0.8 8.4 3.3
Q1 16 2.6 20.1 12.5 4.3 14.5 20.9 6.4 2.6 20.9 11.6
Q17 1.4 4 10.0 0 26.6 6 9.9 9 9.9 9 12.3 3 11.6 6 1.4 4 26.6 6 11.7 7
Q18 5.6 24.9 24.9 24.8 17.9 23.7 17.4 5.6 24.9 19.9
Q19 4.0 20.7 18.1 9.7 11.5 17.6 12.4 4.0 20.7 13.4
Q20 1 .7 6 6.6 5 5.4 6 6.0 3 3.7 6 6.3 5 5.9 1 .7 6 6.6 5 5.1
Q21 7.9 26.9 21.3 17.9 36.3 26.9 38.8 7.9 38.8 25.1
Q22 2.2 5.9 17.0 14.4 6.5 7.6 8.0 2.2 17.0 8.8
RF 1 1 19.9 3 39.0 3 33.6 3 30.9 3 34.2 3 39.1 3 37.3 1 19.9 3 39.1 3 33.4
RF2 6.4 21.0 16.8 20.9 25.4 18.2 16.3 6.4 25.4 17.9
T TPC-H Executive e Summary © 2013 Lenovo Corp. C All rights re eserved
iv