Executive Summary


Executive Summary - Rackcdn.comc970058.r58.cf2.rackcdn.com/individual_results/...

24 downloads 290 Views 635KB Size

Lenovo ThinkServer RD630 Total System Cost

Price / Performance

420,092.4

$0.11 USD

QphH@100GB

Database Size

Database Manager

Operating System

100GB

VectorWise 3.0.0

RedHat Enterprise Linux 6.4

0.8

Report Date: May 10, 2013

Composite Query per Hour Metric

$45,469 USD

RF2 RF1 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1

TPC-H Rev. 2.15.0 TPC-Pricing Rev. 1.7.0

$ / QphH@100GB

Other Software

Availability Date

May 10, 2013

4.1

0 5 Database Load Time = 1:18:35 Load Includes Backup: N Total Data Storage / Database Size = 24.00 Percentage Memory / Database Size = 64.0% System Configuration: Memory: Disk Controller Storage: Total Storage: LAN Controller

TPC-H Executive Summary © 2013 Lenovo Corp. All rights reserved

Geomean _______ 0.8 Arithmetic Mean -------4.1

Throughput Power

10

15 Storage Redundancy Level Base Tables and Auxiliary Data Structures DBMS Temporary Space OS and DBMS Software Lenovo ThinkServer RD630 64 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 M Minimum M Maximu A Average

Q1 1 1.3 7 7.8 6 6.9 6 6.2 9 9.9 9 9.8 1 1.3 9 9.9 7 7.0

Q2 0.3 1.1 1.8 0.9 1.1 0.7 0.3 1.8 1.0

Q3 0.2 0.5 0.7 0.4 0.4 0.5 0.2 0.7 0.5

Q4 Q 0.1 0.3 0.4 0.3 0.4 0.3 0.1 0.4 0.3

Q5 0.4 4 1.6 6 3.5 5 2.4 4 4.2 2 1.6 6 0.4 4 4.2 2 2.3 3

Q6 0.1 0.3 0.2 0.3 0.5 0.3 0.1 0.5 0.3

Q7 0.6 2.8 1.9 1.6 2.5 2.0 0.6 2.8 1.9

Q8 0 0.8 1 .5 2 2.4 5 5.6 2 2.3 2 2.2 0 0.8 5 5.6 2 2.5

Q9 2.9 14.8 12.4 19.9 12.9 16.1 2.9 19.9 13.2

Q10 2.3 5.1 2.2 5.1 7.4 6.7 2.2 7.4 4.8

Q1 11 0.3 1.8 1.0 0.7 0.9 0.6 0.3 1.8 0.9

Q12 0.3 1.4 1.0 0.9 3.3 1.0 0.3 3.3 1.3

Stream  3 ID Q13 0 4 4.2 1 19 9.3 2 11 1.0 3 14 4.7 4 14 4.7 5 12 2.3 M Minimum 4 4.2 M Maximu 19 9.3 A Average 12 2.7

Q14 0.7 2.2 1.3 1.9 1.6 2.5 0.7 2.5 1.7

Q15 0.4 2.6 1.7 0.7 1.9 0.7 0.4 2.6 1.3

Q1 16 1.0 3.3 4.9 2.8 4.7 5.3 1.0 5.3 3.7

Q17 0.5 5 7.0 0 6.9 9 2.8 8 1.7 7 3.1 1 0.5 5 7.0 0 3.7 7

Q18 1.7 6.1 6.9 5.6 5.6 5.7 1.7 6.9 5.3

Q19 1.5 3.6 4.6 4.5 4.3 4.5 1.5 4.6 3.8

Q20 0 0.7 1 .3 3 3.6 1 .6 1 .2 1 .7 0 0.7 3 3.6 1 .7

Q21 2.9 6.6 7.9 8.1 7.3 6.7 2.9 8.1 6.6

Q22 0.8 3.6 2.3 2.6 1.9 3.4 0.8 3.6 2.4

RF 1 6.5 1 12.0 1 12.8 8.3 1 17.3 1 13.7 6.5 1 17.3 1 11.8

RF2 2.1 6.7 3.4 6.5 10.9 0.0 0.0 10.9 4.9

T TPC-H Executive e Summary © 2013 Lenovo Corp. C All rights re eserved

iv