Executive Summary


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

1 downloads 194 Views 168KB Size

Cisco UCS C460 M4 Server

TPC-H Rev. 2.17.1 TPC-Pricing Rev. 2.0 Report Date: 28-Nov-2016

Total System Cost

Composite Query per Hour Metric

Price / Performance

1,115,298.0

$0.87 USD

QphH@10,000GB

$ / QphH@10,000GB

$960,172 USD Database Size

Database Manager

Operating System

10,000GB

Microsoft SQL Server 2016 Enterprise Edition

Windows Server 2016 Standard Edition

Database Load Time = 7h 56m 49s Load Includes Backup: Y Total Data Storage / Database Size = 3.69 Percentage Memory / Database Size = 61.4% System Configuration: Processors/Cores/Threads/Model: Memory: Storage: Table Storage: TPC-H Executive Summary © 2016 Cisco Systems, Inc. All rights reserved

Other Software

Availability Date

28-Nov-2016

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/96/192 Intel(R) Xeon(R) CPU E7-8890 v4 Processor (2.20 GHz, 60MB cache, 165W) 6 TB 8 X 1.6TB 2.5 inch Ent. Performance 6GSATA SSD (3X endurance) 4 X UCS Rack PCIe Storage 6400GB SanDisk SX350 Medium Endurance 37.80 TB

TPC-H Rev. 2.17.1

Cisco Description

TPC-Pricing Rev. 2.0

Cisco UCS C460 M4 Server

Report Date: 28-Nov-2016

Part Number

Brand

Source

Unit Price

Qty

UCSC-C460-M 4 UCS-CPU-E78890E UCSC-M RBD2-12 UCSC-PCIE-RSR-05 UCSC-PSU2V2-1400W CAB-N5K6A-NA UCSC-RAIL-4U UCSC-BRCKT2-C460 UCSC-HS-01-EX UCSC-M RAIDC460 C1UCS-OPT-OUT UCSC-M RAID12G-4GB UCS-SD16TB12S3-EP UCS-M L-1X644RU-G UCS-M 4-V3-LBL UCSC-PCIE-FLR-F UCSC-PCIE-RSR-FLR N20-BBLKD UCSC-F-S64002 RACK-UCS2 CON-PSJ7-C460M 4

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

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

16,500.00 21,000.00 800.00 500.00 800.00 0.00 0.00 0.00 0.00 1,688.00 0.00 1,967.00 7,875.00 3,370.00 0.00 0.00 0.00 0.00 70,533.00 3,429.00 3,161.31

1 4 8 1 4 4 1 1 4 1 1 1 8 96 1 1 1 4 4 1 1

GKM 513 VS207D-P

Provantage Provantage

3 3

16.47 74.15

1 1

Extended Price

3 Year Maint. Price

Server Hardware UCS C460 M 4 base chassis w/o CPU/DIM M /HDD 2.2 GHz E7-8890 v4/165W 24C/60M Cache/DDR4 1866M Hz UCS C460 M 4 DDR4 M emory Riser with 12 DIM M slots Riser card with 5 PCIe slots 1400W V2 AC Power Supply (200 - 240V) 2U & 4U C Series Power Cord, 200/240V 6A North America Rail Kit for UCS C460 M 4 Bracket and Supercap cable for C460 M 4 and 12 drive RAID CPU Heat Sink for UCS C460 M 4 Rack Server Cisco 12G SAS M odular Raid Controller (12 port) Cisco ONE Data Center Compute Opt Out Option Cisco 12Gbps SAS 4GB FBWC Cache module (Raid 0/1/5/6) 1.6TB 2.5 inch Ent. Performance 6GSATA SSD(3X endurance) 64GB DDR4-2133-M Hz LRDIM M /PC4-17000/quad rank/x4/1.2v Cisco M 4 - v3 CPU asset tab ID label (Auto-Expand) Full Height PCIe slot filler for C Series PCIe M odule Filler Panel for UCS C460 M 4 UCS 2.5 inch HDD blanking panel UCS Rack PCIe Storage 6400GB SanDisk SX350 M edium Endurance Cisco R42610 standard rack, w/side panels UCS PSS 24X7X4 OS,UCS C460 M 4 Server

$16,500.00 $84,000.00 $6,400.00 $500.00 $3,200.00 $0.00 $0.00 $0.00 $0.00 $1,688.00 $0.00 $1,967.00 $63,000.00 $323,520.00 $0.00 $0.00 $0.00 $0.00 $282,132.00 $3,429.00 $3,161.31

Server Peripherals IOGEARGKM 513 Spill Proof Keyboard & M ouse Combo ASUS 19.5" VS207D-P Widescreen LED 1600x900 VGA

Subtotal Large Purchase Discount

i

61% for hardware and 35% for services Cisco

1 Hardware Subtotal

$16.47 $74.15 $786,427

$3,161.31

-$479,665 $306,762

-$1,106.46 $2,054.85

Software SQL Server 2016 Enterprise Edition Windows Server 2016 Standard Edition (2 Core Pack) M icrosoft Problem Resolution Services

NA NA NA

M icrosoft M icrosoft M icrosoft

2 2 2

13,472.50 92.00 259.00

48 48 1 Software Subtotal Total

Pricing: 1=Cisco 2=Microsoft 3=Provantage; Audited by Francois Raab from InfoSizing. (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.

$646,680.00 $4,416.00 $651,096.00 $957,857.66

Three-Year Cost of Ownership:

$259.00 $259.00 $2,313.85

$960,172 USD QphH:

1,115,298.0

$ / QphH:

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

Cisco

Cisco UCS C460 M4 Server

TPC-H Rev. 2.17.1 TPC-Pricing Rev. 2.0 Report Date: 28-Nov-2016

Measurement Results 10,000 3.69 61.4 11/05/2016 12:36:34 11/05/2016 20:33:22 00d 07h 56m 49s 9 1,391,173.9 894,129.5 1,115,298.0 $960,172 $0.87

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@10000GB)

Measurement Interval Measurement Interval in Throughput Test (Ts)

Duration of stream execution: Power Run

Throughput Stream

Seed 1105203322 Seed

1

1105203323

2

1105203324

3

1105203325

4

1105203326

5

1105203327

6

1105203328

7

1105203329

8

1105203330

9

1105203331

7,972

Query Start Time Query End Time 2016-11-05 21:47:05 2016-11-05 22:04:57

Duration (sec)

Query Start Time Query End Time 2016-11-05 22:07:15 2016-11-05 23:46:35 2016-11-05 22:07:15 2016-11-05 23:36:00 2016-11-05 22:07:15 2016-11-05 23:28:54 2016-11-05 22:07:15 2016-11-05 23:46:12 2016-11-05 22:07:15 2016-11-05 23:43:22 2016-11-05 22:07:15 2016-11-05 23:42:31 2016-11-05 22:07:15 2016-11-05 23:45:41 2016-11-05 22:07:15 2016-11-05 23:44:45 2016-11-05 22:07:15 2016-11-05 23:37:47

Duration (sec)

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

1,072

5,960 5,325 4,899 5,937 5,767 5,716 5,906 5,850 5,432

RF1 Start Time RF1 End Time 2016-11-05 21:45:12 2016-11-05 21:47:04

RF2 Start Time RF2 End Time 2016-11-05 22:04:57 2016-11-05 22:07:16

RF1 Start Time RF1 End Time 2016-11-05 23:46:34 2016-11-05 23:48:12 2016-11-05 23:50:31 2016-11-05 23:51:54 2016-11-05 23:54:09 2016-11-05 23:55:29 2016-11-05 23:57:47 2016-11-05 23:59:05 2016-11-06 00:01:27 2016-11-06 00:02:45 2016-11-06 00:05:06 2016-11-06 00:06:40 2016-11-06 00:09:11 2016-11-06 00:10:28 2016-11-06 00:12:49 2016-11-06 00:14:04 2016-11-06 00:16:30 2016-11-06 00:17:46

RF2 Start Time RF2 End Time 2016-11-05 23:48:12 2016-11-05 23:50:30 2016-11-05 23:51:54 2016-11-05 23:54:09 2016-11-05 23:55:29 2016-11-05 23:57:46 2016-11-05 23:59:05 2016-11-06 00:01:27 2016-11-06 00:02:45 2016-11-06 00:05:06 2016-11-06 00:06:40 2016-11-06 00:09:10 2016-11-06 00:10:28 2016-11-06 00:12:48 2016-11-06 00:14:04 2016-11-06 00:16:29 2016-11-06 00:17:46 2016-11-06 00:20:07

TPC-H Rev. 2.17.1 TPC-Pricing Rev. 2.0

Cisco UCS C460 M4 Server

Cisco

Report Date: 28-Nov-2016

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

Stream ID 0 1 2 3 4 5 6 7 8 9 Minimum Average Maximum

Q1

Q2

Q3

Q4

Q5

Q6

Q7

Q8

Q9

Q10

Q11

Q12

13.2 23.8 30.7 37.7 20.9 37.5 33.0 274.4 32.0 30.3 13.2 53.4 274.4

18.2 40.7 62.4 49.7 50.8 47.5 39.5 37.2 38.6 47.4 18.2 43.2 62.4

26.4 171.0 218.7 154.0 47.6 182.1 167.2 337.0 203.3 388.7 26.4 189.6 388.7

27.8 29.4 114.6 131.0 165.3 327.0 125.7 167.7 299.1 167.6 27.8 155.5 327.0

31.8 225.4 249.3 188.7 191.8 182.8 220.0 217.4 215.9 175.5 31.8 189.9 249.3

0.8 9.9 22.8 4.6 56.7 79.2 51.8 22.5 29.0 5.3 0.8 28.3 79.2

20.4 438.5 136.9 239.0 141.8 147.3 329.2 206.0 160.7 198.4 20.4 201.8 438.5

31.1 181.2 287.1 190.1 248.0 170.4 378.2 232.4 198.1 185.8 31.1 210.2 378.2

286.8 181.7 284.3 309.1 455.4 311.6 499.0 501.6 660.2 299.4 181.7 378.9 660.2

16.8 251.3 252.1 264.7 270.5 173.9 202.1 254.3 451.2 258.3 16.8 239.5 451.2

45.7 148.2 145.7 164.2 136.8 239.5 204.9 126.4 115.1 220.3 45.7 154.7 239.5

9.2 443.9 374.9 400.8 414.7 361.5 570.3 55.3 132.4 101.6 9.2 286.5 570.3

Q13

Q14

Q15

Q16

Q17

Q18

Q19

Q20

Q21

Q22

RF1

RF2

212.0 795.7 435.5 510.9 584.3 488.8 637.5 741.1 518.9 814.6 212.0 573.9 814.6

7.1 21.7 39.1 33.8 33.1 31.1 35.9 17.9 33.4 34.3 7.1 28.7 39.1

11.1 90.4 29.8 127.9 58.2 99.7 79.0 30.4 99.9 94.1 11.1 72.1 127.9

30.3 218.9 243.1 267.3 97.6 281.3 220.3 149.3 167.7 168.7 30.3 184.5 281.3

9.6 333.4 83.0 65.2 88.7 96.5 139.3 240.7 226.3 198.1 9.6 148.1 333.4

143.3 1,223.1 866.2 730.3 1,429.9 1,245.2 658.6 1,286.0 856.9 869.6 143.3 930.9 1,429.9

4.4 261.6 211.7 301.4 520.7 168.1 34.5 284.4 203.3 207.1 4.4 219.7 520.7

19.0 121.3 164.1 132.3 38.1 165.9 158.1 164.0 143.9 100.6 19.0 120.7 165.9

88.9 710.8 810.1 459.6 767.7 768.8 666.6 418.7 762.4 725.2 88.9 617.9 810.1

17.5 36.8 261.4 135.7 116.6 160.6 263.7 140.8 300.6 139.8 17.5 157.4 300.6

112.5 97.3 82.9 79.8 78.4 77.7 93.3 77.2 75.1 76.2 75.1 85.0 112.5

138.4 138.0 135.3 137.0 141.4 141.2 150.6 140.5 145.4 141.2 135.3 140.9 150.6

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