Executive Summary


[PDF]Executive Summary - Rackcdn.comc970058.r58.cf2.rackcdn.com/...

4 downloads 101 Views 293KB Size

Cisco UCS C420 M3 Server

TPC-H Rev. 2.16.0 TPC-Pricing Rev. 1.7.0 Report Date: October 17, 2013

Total System Cost

Composite Query per Hour Metric

Price / Performance

$299,680 USD

233,219.6

$1.29 USD

QphH@3000GB

$ / QphH@3000GB

Other Software

Database Size

Database Manager

Operating System

3000GB

Sybase IQ Version 16.0 SP02

Red Hat Enterprise Linux Server Release 6.4

RF2 RF1 Q22 Q21 Q20 Q19 Q18 Q17 Q16 Q15 Q14 Q13 Q12 Q11 Q10 Q9 Q8 Q7 Q6 Q5 Q4 Q3 Q2 Q1

Availability Date December 30, 2013

Throughput Power

36.5 464.3

0.0

200.0

400.0

Database Load Time = 2h 24m 26s Load Includes Backup: N Total Data Storage / Database Size = 4.53 Percentage Memory / Database Size = 33.3% System Configuration: Processors/Cores/Threads/Model: Memory: Storage: Table Storage:

TPC-H Executive Summary © 2013 Cisco Systems, Inc. All rights reserved

600.0

800.0

1,000.0

Geometric mean(Power) Arithmatic Mean( Throughput)

1,200.0

1,400.0

Storage Redundancy Level Base Tables and Auxiliary Data Structures 1 DBMS Temporary Space 0 OS and DBMS Software 1 Cisco UCS C420 M3 Server 4/32/64 Intel Xeon E5-4650 Processor (2.7 GHz, 20MB cache, 130W) 1024 GB 8 x 600GB 6Gb SAS 10K RPM SFF HDD 8 x Cisco UCS 200 GB SATA 2.5" Enterprise Performance SSD 6 x Cisco UCS Fusion ioDrive2 1205M Adapter 13.6 TB

TPC-H Rev. 2.16.0

Cisco Description

Cisco UCS C430 M3 Server

TPC-Pricing Rev. 1.7.0

Report Date: Part Number

Brand

UCSC-C420-M3 CON-SNTP-C420M3 UCS-CPU-E5-4650 UCS-ML-1X324RY-A A03-D600GA2 UCS-SD200G0KA2-E UCSC-F-FIO-1205M CAB-250V-10A-CN UCSC-PSU2-1200 UCS-RAID9271CV-8I UCSC-CABLE-L UCSC-CABLE-S UCSC-HS-C420M3 UCSC-PCIF-01F UCSC-PCIF-01H UCSC-RAIL-2U RHEL-4S-1G-3A CON-ISV1-RH4S1G3A UCSC-DBKP-08D GKM502 UM.BV3AA.D01 RACK-UCS

Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Ci s co Prova nta ge Prova nta ge Ci s co

Source

Unit Price

Qty

Extended Price

17-Oct-2013 3 Year Maint. Price

Server Hardware and OS UCS C420 M3 w/o CPU mem HDD PCIe PSU ra i l ki t SMARTNET 24X7X4 UCS C420 M3 Server, 36 Month(s ) 2.70 GHz E5-4650 130W 8C/20MB Ca che/DDR3 1600MHz 32GB DDR3-1600-MHz LR DIMM/PC3-12800/qua d ra nk/x4/1.35v 600GB 6Gb SAS 10K RPM SFF HDD/hot pl ug/dri ve s l ed mounted 200GB 2.5 SATA Enterpri s e performa nce SSD Ci s co UCS 1205GB MLC Fus i on i oDri ve2 AC Power Cord - 250V 10A - PRC 1200W 2u Power Suppl y For UCS Mega RAID 9271CV wi th 8 i nterna l SAS/SATA ports wi th Superca p SAS/SATA ca bl e (l ong) for C420 M3 SAS/SATA ca bl e (s hort) for C420 M3 Hea ts i nk for the C420 M3 Ful l hei ght PCIe fi l l er for C-Seri es Ha l f hei ght PCIe fi l l er for UCS 2U Ra i l Ki t for UCS C-Seri es s ervers RHEL/4 Socket/1 Gues t/3Yr Svcs Requi red ISV 24X7 Rhel /4 Socket/1 Gues t 36 Month(s ) 8 Dri ve Ba ckpl a ne For C-Seri es IOGEAR GKM502 Compa ct Wi red Keyboa rd a nd Mous e Combo Acer 17" V173 DJOb LCD Moni tor 1280X1024 Ci s co R42610 expa ns i on ra ck La rge Purcha s e Di s count i

57.0% Ci s co

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 3 1

7,500.00 2,349.00 10,255.00 2,639.00 1,086.00 4,400.00 37,500.00 0.00 652.00 1,686.00 Incl uded Incl uded Incl uded Incl uded Incl uded Incl uded Incl uded 9,588.00 313.00 $11 $112 $2,857

1 1 4 32 8 8 6 2 2 2 2 2 4 2 3 1 1 1 2 1 1 1 Subtota l

1 Ha rdwa re Subtota l

Softwa re Syba s e IQ Si ngl e App Svr, per cpu core 3 yr s upport Si ngl e App Svr, per cpu core Syba s e IQ Softwa re Support (15% of Net)

13545 98480 NA

SAP SAP SAP

Pricing: 1=Cisco 2=SAP 3=Provantage; Audited by Francois Raab from InfoSizing, Inc. (sizing.com) All discounts are based on US list prices and for similar quantities and configurations. The discounts are based on the overall specific components pricing from respective vendors in this single quotation. Discounts for similarly sized configurations will be similar to those quoted here, but may vary based on the components in the configuration.

2 2 2

$2,595 $1,713

32 32

$7,500 $2,349 $41,020 $84,448 $8,688 $35,200 $225,000 $0 $1,304 $3,372

$2,349

$9,588 $626 $11 $112 $2,857 $412,487 -$235,117 $177,369

$11,937 -$6,804 $5,133

$83,040

-$12,456 Softwa re Subtota $70,584 l Tota l $247,953

Three-Year Cost of Ownership:

$54,816 -$8,222 $46,594 $51,727

$299,680 USD

QphH:

233,219.6

$ / QphH:

$1.29 USD

Prices used in TPC benchmarks reflect the actual prices a customer would pay for a one-time purchase of the stated components. Individually negotiated discounts are not permitted. Special prices based on assumptions about past or future purchases are not permitted. All discounts reflect standard pricing policies for the listed components. For complete details, see the pricing sections of the TPC benchmark specifications. If you find that the stated prices are not available according to these terms, please inform at [email protected]. Thank you.

TPC-H Executive Summary © 2013 Cisco Systems, Inc. All rights reserved

Cisco

Cisco UCS C420 M3 Server

TPC-H Rev. 2.16.0 TPC-Pricing Rev. 1.7.0 October 17, 2013

Measurement Results Database Scaling (SF/Size) Total Data Storage/Database Size Percentage Memory/Database Size Start of Database Load Time End of Database Load Time Database Load Time Query Streams for Throughput Test (S) TPC-H Power TPC-H Throughput TPC-H Composite Total System Price Over 3 Years TPC-H Price/Performance Metric ($/QphH@3000GB)

3,000 4.53 33.3 10/02/2013 11:00:08 10/02/2013 13.24:34 02:24:26 8 295,707.5 183,936.5 233,219.6 $299,680 $1.29

Measurement Interval Measurement Interval in Throughput Test (Ts)

10,334

Duration of throughput stream execution: Power Run

Seed 1002132434

Stream

Seed

1

1002132435

2

1002132436

3

1002132437

4

1002132438

5

1002132439

6

1002132440

7

1002132441

8

1002132442

Query Start Time Query End Time 10/02//2013 13:24:54 10/02//2013 13:47:50

Query Start Time Query End Time 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013

TPC-H Executive Summary © 2013 Cisco Systems, Inc. All rights reserved

13:48:11 16:40:25 13:48:11 16:34:26 13:48:11 16:38:30 13:48:11 16:39:55 13:48:11 16:39:53 13:48:11 16:39:05 13:48:11 16:39:31 13:48:11 16:35:44

Duration (sec) 1,375

Duration (sec) 10,333 9,974 10,218 10,303 10,301 10,253 10,279 10,052

RF1 Start Time RF1 End Time

RF2 Start Time RF2 End Time

10/02/2013 13:24:35

10/02/2013 13:47:50

10/02/2013 13:24:49

10/02/2013 13:48:11

RF1 Start Time RF1 End Time

RF2 Start Time RF2 End Time

10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013

13:49:11 13:54:29 13:58:23 14:01:07 14:12:18 14:14:07 14:25:32 14:28:28 14:34:22 14:36:40 14:46:53 14:48:43 15:06:12 15:08:26 15:12:39 15:14:38

10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013 10/02/2013

13:54:30 13:58:23 14:01:07 14:12:18 14:14:07 14:25:32 14:28:28 14:34:21 14:36:41 14:46:52 14:48:43 15:06:12 15:08:26 15:12:39 15:14:39 15:20:47

Cisco

TPC-H Rev. 2.16.0 TPC-Pricing Rev. 1.7.0

Cisco UCS C420 M3 Server

October 17, 2013

TPC-H Timing Intervals (in seconds) Duration of stream execution: Stream Q1 Q2 ID 0 179.0 9.1 1 948.5 45.0 2 1,155.4 50.4 3 1,170.3 75.8 4 1,166.9 86.1 5 1,039.1 52.8

Q3

Q4

Q5

Q6

Q7

Q8

Q9

Q10

Q11

Q12

5.3 36.8 101.1

37.9 318.2 256.8

72.1 581.4 608.5

203.3 1,139.8 1,144.6

63.9 419.0 486.4

19.2 70.3 85.4

30.0 170.1 221.5

35.2 252.0 300.0

36.7 115.0 35.5 906.3 269.3 1,043.6 239.2 225.7 235.5 274.9

761.2 852.1 909.2 876.1

53.6 56.7 49.9 53.7

292.0 334.7 327.2 385.3

708.4 639.1 613.2 665.1

1,203.3 1,254.3 910.8 1,056.2

377.0 516.1 471.0 622.9

111.3 157.2 118.7 120.7

178.3 255.1 247.8 234.7

6 7 8

1,063.8

55.2

204.1 198.4 230.1 322.1

1,018.2 1,059.7

84.0 55.1

277.9 322.7

218.5 340.0

683.3 787.8

46.4 59.8

278.8 193.0

721.3 665.3

1,232.1 1,229.1

554.4 98.8 412.6 114.7

111.6 260.1

Minimum

948.5 1,170.3 1,077.7

45.0 86.1 63.1

198.4 322.7 263.4

35.5 683.3 340.0 1,043.6 229.8 852.5

36.8 101.1 57.3

193.0 385.3 298.3

581.4 721.3 650.3

910.8 1,254.3 1,146.3

377.0 70.3 622.9 157.2 482.4 109.6

111.6 260.1 209.9

Q13

Q14

Q15

Q16

Q18

Q19

Q20

Q21

Q22

RF1

RF2

155.7 1,256.5 973.3 1,071.3 1,116.5

17.3 202.0 210.4 116.7 147.5

26.2 243.1 132.3 174.4 295.2

17.0 33.2 97.0 1,037.2 149.7 792.6 170.5 1,083.2 173.3 898.0

143.3 859.7 638.9 771.1 710.7

19.4 144.8 95.4 102.1 92.3

20.9 198.8 183.1 218.0 75.1

120.9 1,055.4 843.7 913.8 779.2

14.4 316.3 232.4 223.2 273.9

14.3 318.0 163.8 108.2 175.7

6

1,328.2 143.3 228.5 1,203.7 164.3 206.5

116.2 172.2

923.6 895.7

989.7 922.7

124.7 80.7

199.0 153.6

789.1 585.8

7

1,170.6 103.3 114.6

134.9

936.7

985.1

120.1

154.4

1,011.2

223.6 134.2

8 Maximum

918.0 129.0 121.8 918.0 103.3 114.6 1,328.2 210.4 295.2

130.6 988.2 97.0 792.6 173.3 1,083.2

874.9 638.9 989.7

142.0 80.7 144.8

227.9 75.1 227.9

737.9 585.8 1,055.4

282.5 119.4 368.2 137.3 108.2 233.1 316.3 318.0 1,048.4

Average

1,129.8 152.1 189.6

143.1

844.1

112.8

176.2

839.5

Maximum Average

Stream ID 0 1 2 3 4 5

Minimum

TPC-H Executive Summary © 2013 Cisco Systems, Inc. All rights reserved

Q17

944.4

21.0 233.1 670.5 684.9 353.2

253.6 138.7 611.8 137.3 110.1 1,048.4

242.9 158.5

252.8

527.9