Executive Summary


[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