Executive Summary


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

2 downloads 102 Views 279KB Size

Cisco UCS C460 M4 Server

TPC-H Rev. 2.17.1 TPC-Pricing Rev. 2.0.0 Report Date: 13-Jul-2015

Total System Cost

Composite Query per Hour Metric

Price / Performance

725,686.2

$1.08 USD

QphH@3000GB

$ / QphH@3000GB

$781,536 USD Database Size

Database Manager

Operating System

3000GB

Microsoft SQL Server 2014 Enterprise Edition

Windows 2012 R2 Standard Edition

Database Load Time = 17h 44m 48s Load Includes Backup: Y Total Data Storage / Database Size = 6.85 Percentage Memory / Database Size = 102% System Configuration: Processors/Cores/Threads/Model: Memory: Storage: Table Storage: TPC-H Executive Summary © 2015 Cisco Systems, Inc. All rights reserved

Other Software

Availability Date

13-Jul-2015

Storage Redundancy Level Base Tables and Auxiliary Data Structures 0 DBMS Temporary Space 0 OS and DBMS Software 1 Cisco UCS C460 M4 Server 4/72/144 Intel Xeon E7-8890 v3 Processor (2.5 GHz, 45MB cache, 165W) 3 TB 12 X 400GB 12Gb SAS 2.5 inch Enterprise performance SSD 6 X UCS 3200GB Fusion ioMemory3SX Scale line for C-Series cards 24 TB

TPC-H Rev. 2.17.1

Cisco Description

TPC-Pricing Rev. 2.0.0

Cisco UCS C460 M4 Server

Report Date: 13-JUL-2015

Part Number

Brand

UCS C460 M4 base chassis w/o CPU/DIMM/HDD 3YR SMARTNET 24X7X4UCS C460 M4 Server 2.5GHz E7-8890 v3/165W/18C/45M Cache 32GB DDR4-2133-MHz RDIMM/PC4-17000/dual rank/x4/1.2v UCS C460 M4 DDR4 Memory Riser with 12 DIMM slots Riser card with 5 PCIe slots 400GB 2.5 inch Enterprise performance 12G SAS SSD 1400W V2 AC Power Supply for 2U & 4U C-Series Servers Power Cord 200/240V 6A North America Full Height PCIe slot filler for C Series Bracket and Supercap cable for C460 M4 and 12 drive RAID CPU Heat Sink for UCS C460 M4 Rack Server Rail Kit for UCS C460 M4 Cisco 12G SAS Modular Raid Controller (12 port) Cisco 12Gbps SAS 1GB FBWC Cache module (Raid 0/1/5/6) UCS 3200GB Fusion ioMemory3SX Scale line for C-Series 3YR SMARTNET 24X7X4 UCS 3200GB Fusion ioMemory3SX Scale Cisco ONE Data Center Compute Opt Out Option Cisco R42610 standard rack w/side panels ONSITE 8X5XNBD Cisco R42610 expansion rack no side panel(36 months)

UCSC-C460-M4 CON-3SNTP-C460M4 UCS-CPU-E78890D UCS-MR-1X322RU-G UCSC-MRBD2-12 UCSC-PCIE-RSR-05 UCS-SD400G12S2-EP UCSC-PSU2V2-1400W CAB-N5K6A-NA UCSC-PCIE-FLR-F UCSC-BRCKT2-C460 UCSC-HS-01-EX UCSC-RAIL-4U UCSC-MRAIDC460 UCSC-MRAID12G-1GB UCSC-F-FIO-3200SS CON-3SNTP-FIOC32SS C1UCS-OPT-OUT RACK-UCS2 CON-OS-R42610

Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco Cisco

IOGEARGKM513 Spill Proof Keyboard & Mouse Combo ASUS 19.5" VS207D-P Widescreen LED 1600x900 VGA

GKM513 VS207D-P

Provantage Provantage

Source

Unit Price

Qty

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

16,500.00 2,967.00 21,000.00 1,800.00 800.00 500.00 6,299.00 800.00 0.00 0.00 0.00 0.00 0.00 1,688.00 1,217.00 49,200.00 1,434.00 0.00 3,429.00 267.00

1 1 4 96 8 2 12 4 4 4 1 4 1 1 1 6 6 1 1 6

3 3

16.76 88.59

1 1

Extended Price

3 Year Maint. Price

Server Hardware

Subtotal Large Purchase Discount

i

57% for hadrware and 35% for services

Cisco

1

$16,500.00 $2,967.00 $84,000.00 $172,800.00 $6,400.00 $1,000.00 $75,588.00 $3,200.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,688.00 $1,217.00 $295,200.00 $8,604.00 $0.00 $3,429.00 $1,602.00 $16.76 $88.59 $661,127 -$376,843 $284,285

Hardware Subtotal

$13,173.00 -$4,610.55 $8,562.45

Software SQL Server 2014 Enterprise Edition Windows Server 2012 R2 Standard Edition 2 Processor License   Windows Server 2012 R2 Client Access License Microsoft Problem Resolution Services

7JQ-00750 P73-06284 R18-04280 NA

Microsoft Microsoft Microsoft Microsoft

2 2 2 2

13,472.50 735.00 24.36 259.00

36 2 80 1 Software Subtotal Total

Pricing: 1=Cisco 2=Microsoft 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.

$485,010.00 $1,470.00 $1,948.80 $488,428.80 $772,713.56

Three-Year Cost of Ownership:

$259.00 $259.00 $8,821.45

$781,536 USD

QphH:

725,686.2

$ / QphH:

$1.08 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 © 2015 Cisco Systems, Inc. All rights reserved

Cisco

Cisco UCS C460 M4 Server

TPC-H Rev. 2.17.1 TPC-Pricing Rev. 2.0.0 Report Date: 13-Jul-2015

Measurement Results 3,000 6.85 102 07/03/2015 15:53:51 07/04/2015 09:38:39 00d 17h 44m 48s 8 961,093.5 547,938.9 725,686.2 $781,536 $1.08

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)

Measurement Interval Measurement Interval in Throughput Test (Ts)

Duration of stream execution: Power Run

Throughput Stream

Seed 704093839 Seed

1

704093840

2

704093841

3

704093842

4

704093843

5

704093844

6

704093845

7

704093846

8

704093847

3,469

Query Start Time Query End Time 2015-07-04 10:50:06 2015-07-04 10:55:40

Duration (sec)

Query Start Time Query End Time 2015-07-04 10:57:00 2015-07-04 11:35:01 2015-07-04 10:57:00 2015-07-04 11:37:01 2015-07-04 10:57:00 2015-07-04 11:34:12 2015-07-04 10:57:00 2015-07-04 11:35:59 2015-07-04 10:57:01 2015-07-04 11:36:20 2015-07-04 10:57:01 2015-07-04 11:37:40 2015-07-04 10:57:01 2015-07-04 11:34:03 2015-07-04 10:57:01 2015-07-04 11:35:42

Duration (sec)

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

334

2,281 2,401 2,232 2,339 2,359 2,439 2,222 2,321

RF1 Start Time RF1 End Time 2015-07-04 10:49:06 2015-07-04 10:50:07

RF2 Start Time RF2 End Time 2015-07-04 10:55:39 2015-07-04 10:57:01

RF1 Start Time RF1 End Time 2015-07-04 11:37:40 2015-07-04 11:38:44 2015-07-04 11:39:51 2015-07-04 11:40:57 2015-07-04 11:42:01 2015-07-04 11:43:02 2015-07-04 11:44:08 2015-07-04 11:45:08 2015-07-04 11:46:07 2015-07-04 11:47:06 2015-07-04 11:48:17 2015-07-04 11:49:17 2015-07-04 11:50:22 2015-07-04 11:51:23 2015-07-04 11:52:30 2015-07-04 11:53:43

RF2 Start Time RF2 End Time 2015-07-04 11:38:44 2015-07-04 11:39:51 2015-07-04 11:40:57 2015-07-04 11:42:01 2015-07-04 11:43:02 2015-07-04 11:44:08 2015-07-04 11:45:08 2015-07-04 11:46:06 2015-07-04 11:47:06 2015-07-04 11:48:17 2015-07-04 11:49:17 2015-07-04 11:50:22 2015-07-04 11:51:23 2015-07-04 11:52:29 2015-07-04 11:53:43 2015-07-04 11:54:49

TPC-H Rev. 2.17.1 TPC-Pricing Rev. 2.0.0

Cisco UCS C460 M4 Server

Cisco

Report Date: 13-Jul-2015

TPC-H Timing Intervals (in seconds) Stream ID 0 1 2 3 4 5 6 7 8

Q1

Q2

Q3

Q4

Q5

Q6

Q7

Q8

Q9

Maximum

10.7 105.1 69.0 24.7 14.7 77.9 78.7 18.3 13.8 10.7 45.9 105.1

1.3 6.8 9.0 10.5 2.5 11.8 10.8 12.7 11.2 1.3 8.5 12.7

12.0 88.5 87.2 139.3 67.1 133.7 95.2 78.8 78.9 12.0 86.7 139.3

14.1 61.6 169.3 68.6 37.5 111.6 141.2 135.4 133.6 14.1 97.0 169.3

16.5 83.7 73.7 55.8 153.8 119.9 124.8 76.7 137.7 16.5 93.6 153.8

1.3 17.1 97.7 36.1 68.9 54.3 24.7 79.2 107.2 1.3 54.1 107.2

7.4 58.4 102.4 176.9 209.4 46.4 71.1 140.8 56.5 7.4 96.6 209.4

12.7 721.7 560.0 584.1 551.8 706.3 631.0 485.5 452.4 12.7 522.8 721.7

Stream ID

Q13

Q14

Q15

Q16

Q17

Q18

Q19

0

41.1 66.9 82.7 107.8 108.8 45.6 53.7 51.9 56.3 41.1 68.3 108.8

2.6 116.9 49.9 56.2 27.4 38.7 55.0 96.0 88.6 2.6 59.0 116.9

4.3 92.9 70.6 37.0 32.2 62.7 97.8 109.8 103.2 4.3 67.8 109.8

6.1 8.3 21.8 16.6 12.6 16.4 16.3 8.3 24.7 6.1 14.6 24.7

6.1 13.9 164.1 12.4 8.7 16.9 69.8 15.4 74.1 6.1 42.4 164.1

56.8 148.2 256.1 191.6 210.3 70.2 323.5 229.5 110.4 56.8 177.4 323.5

5.5 102.9 94.0 31.7 123.9 56.6 6.9 6.5 71.1 5.5 55.5 123.9

Minimum Average

1 2 3 4 5 6 7 8 Minimum Average Maximum

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

Q10

Q11

Q12

34.0 58.1 53.0 61.3 58.0 36.8 63.9 40.7 103.7 34.0 56.6 103.7

29.1 155.8 68.4 120.1 226.1 81.6 180.1 182.6 205.1 29.1 138.8 226.1

13.6 66.7 69.5 122.7 84.4 39.9 62.9 63.8 77.2 13.6 66.7 122.7

5.4 14.0 80.3 139.8 99.8 221.3 199.2 185.3 118.6 5.4 118.2 221.3

Q20

Q21

Q22

RF1

RF2

7.3 59.5 137.1 143.9 49.1 149.3 76.2 73.4 150.8 7.3 94.1 150.8

38.9 195.4 62.1 80.5 105.5 203.0 38.9 59.6 104.7 38.9 98.7 203.0

6.5 37.0 22.2 12.9 85.1 57.5 17.2 71.1 40.2 6.5 38.9 85.1

59.7 63.1 65.6 60.3 59.4 59.1 59.4 60.2 73.0 59.1 62.2 73.0

81.0 67.1 64.4 66.2 58.4 71.4 65.3 66.7 66.1 58.4 67.4 81.0