Executive Summary


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

5 downloads 171 Views 270KB Size

Cisco UCS C460 M4 Server

TPC-H Rev. 2.17.0 TPC-Pricing Rev. 2.0.0 Report Date: 15-Dec-2014 Revised: 17-Dec-2014

Composite Query per Hour Metric

Price / Performance

588,831.5

$0.97 USD

Total System Cost

$571,047 USD

QphH@1000GB

Database Size

Database Manager

Operating System

1000GB

Microsoft SQL Server 2014 Enterprise Edition

Windows 2012 R2 Standard Edition

Database Load Time = 05h 41m 13s Load Includes Backup: Y Total Data Storage / Database Size = 10.63 Percentage Memory / Database Size = 153.6% System Configuration: Processors/Cores/Threads/Model: Memory: Storage: Table Storage: TPC-H Executive Summary © 2014 Cisco Systems, Inc. All rights reserved

$ / QphH@1000GB

Other Software

Availability Date

15-Dec-2014

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/60/120 Intel Xeon E7-4890 v2 Processor (2.8 GHz, 37.5MB cache, 155W) 1.5 TB 2 X 400 GB 12 Gb SAS 2.5 inch Enterprise performance SSD 6 X 1.6 TB 12 Gb SAS 2.5 inch Enterprise performance SSD 10.63 TB

TPC-H Rev. 2.17.0

Cisco Description

TPC-Pricing Rev. 2.0.0

Cisco UCS C460 M4 Server Part Number

Brand

UCS C460 M4 base chassis w/o CPU/DIMM/HDD UCS C460 M4 ServerSMARTnet Onsite Premium 24x7x4 (36 months) 2.8 GHz E7-4890 v2/155W 15C/37.5M Cache/DDR3 1600MHz Mem kit for UCS-MR-2X162RY-E 2 X 16 GB DDR3-1600 MHz RDIMM/PC3-12800 dual rank/x4/1.35v Riser card with 5 PCIe slots Memory riser with 12 DIMM slots 1.6TB2.5 inch Enterprise performance 12G SAS SSD 400GB 2.5 inch Enterprise performance 12G SAS SSD 1400W AC Power Supply for 2U & 4U C Series Servers Power Cord 200/240V 6A North America CPU Heat Sink for UCS C460 M4 Rack Server UCS 2.5 inch HDD blanking panel Rail Kit for UCS C460 M4 Full Height PCIe slot filler for C Series MegaRAID 9361CV with 8 internal SAS/SATA ports with Supercap Cisco R42610 standard rack w/side panels

UCSC-C460-M4 CON-OSP-C460M4 UCS-CPU-E74890B UCS-MKIT-162RY-E UCS-MR-2X162RY-E UCSC-PCIE-RSR-05 UCSC-MRBD-12 UCS-SD16T12S2-EP UCS-SD400G12S2-EP UCSC-PSU2-1400W CAB-N5K6A-NA UCSC-HS-01-EX N20-BBLKD UCSC-RAIL-4U UCSC-PCIE-FLR-F UCS-RAID9361CV-8I RACK-UCS2

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

Report Date: 15-Dec-2014 Revised: 17-Dec-2014

Unit Price

Qty

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

16,500.00 3,321.00 19,700.00 0.00 1,559.00 500.00 750.00 29,000.00 7,700.00 800.00 0.00 0.00 0.00 $0 $0 $3,500 $3,429

1 1 4 96 48 2 8 6 2 4 4 4 4 1 10 1 1

3 3

$17 $89

1 1

Extended Price

3 Year Maint. Price

Server Hardware

Subtotal Large Purchase Discount i

57.0% Cisco

1 Hardware Subtotal

$16,500 $3,321 $78,800 $0 $74,832 $1,000 $6,000 $174,000 $15,400 $3,200 $0 $0 $0 $0 $0 $3,500 $3,429

$17 $89 $376,766 -$214,757 $162,010

$3,321 -$1,893 $1,428

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,473 $735 $24 $259

30 2 70 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.

$404,175 $1,470 $1,705 $407,350 $569,360

Three-Year Cost of Ownership:

$259 $259 $1,687

$571,047 USD

QphH:

588,831.5

$ / QphH:

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

Cisco

Cisco UCS C460 M4 Server

TPC-H Rev. 2.17.0 TPC-Pricing Rev. 2.0.0 Report Date: 15-Dec-2014 Revised: 17-Dec-2014

Measurement Results 1,000 10.63 153.6 12/8/2014 9:28:53 12/8/2014 15:10:05 05h 41m 13s 7 761,739.0 455,172.40 588,831.50 $571,047 $0.97

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

Measurement Interval Measurement Interval in Throughput Test (Ts)

1, 218

Duration of stream execution: Seed

Query Start Time Query End Time

Duration (sec)

RF1 Start Time RF1 End Time

RF2 Start Time RF2 End Time

1208151005

2014-12-08 15:41:55 2014-12-08 15:44:13

138

2014-12-08 15:41:29 2014-12-08 15:41:55

2014-12-08 15:44:13 2014-12-08 15:44:43

RF1 Start Time

RF2 Start Time

RF1 End Time

RF2 End Time

2014-12-08 15:58:34 2014-12-08 15:59:01 2014-12-08 15:59:26 2014-12-08 15:59:54 2014-12-08 16:00:19 2014-12-08 16:00:48 2014-12-08 16:01:18 2014-12-08 16:01:46 2014-12-08 16:02:12 2014-12-08 16:02:41 2014-12-08 16:03:08 2014-12-08 16:03:34 2014-12-08 16:03:57

2014-12-08 15:59:00 2014-12-08 15:59:27 2014-12-08 15:59:53 2014-12-08 16:00:20 2014-12-08 16:00:47 2014-12-08 16:01:19 2014-12-08 16:01:45 2014-12-08 16:02:13 2014-12-08 16:02:40 2014-12-08 16:03:09 2014-12-08 16:03:34 2014-12-08 16:03:58 2014-12-08 16:04:35

2014-12-08 16:04:36

2014-12-08 16:05:00

Power Run

Throughput Stream

Seed

1

1208151006

2

1208151007

3

1208151008

4

1208151009

5

1208151010

6

1208151011

7

1208151012

Query Start Time Query End Time 2014-12-08 15:44:42 2014-12-08 15:57:35 2014-12-08 15:44:42 2014-12-08 15:58:13 2014-12-08 15:44:42 2014-12-08 15:57:56 2014-12-08 15:44:42 2014-12-08 15:58:19 2014-12-08 15:44:42 2014-12-08 15:58:34 2014-12-08 15:44:42 2014-12-08 15:57:53 2014-12-08 15:44:42 2014-12-08 15:58:20

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

Duration (sec) 773 811 794 817 832 791 818

Cisco

Cisco UCS C460 M4 Server

TPC-H Rev. 2.17.0 TPC-Pricing Rev. 2.0.0 Report Date: 15-Dec-2014 Revised: 17-Dec-2014

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

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

Q1 4.1 4.2 5.2 9.8 8.4 8.2 8.1 4.9 4.1 6.6 9.8

Q2 0.8 7.2 3.5 1.5 1.9 17.6 3.6 1.0 0.8 4.6 17.6

Q3 4.7 49.2 36.7 41.3 52.5 64.9 70.0 49.0 4.7 46.0 70.0

Q4 5.3 14.5 26.4 40.7 33.0 21.5 27.6 15.1 5.3 23.0 40.7

Q5 5.9 28.4 29.2 35.6 57.8 30.5 38.8 22.5 5.9 31.1 57.8

Q6 0.7 22.1 54.5 11.3 18.1 38.5 46.0 25.9 0.7 27.1 54.5

Q7 2.8 55.4 40.9 33.7 57.5 26.3 14.9 52.8 2.8 35.5 57.5

Q8 4.3 33.5 32.1 51.4 46.5 49.8 26.9 46.1 4.3 36.3 51.4

Q9 12.9 15.3 28.4 52.3 54.5 13.0 39.1 31.5 12.9 30.9 54.5

Q10 20.2 194.6 249.3 222.4 176.7 261.6 252.1 247.0 20.2 203.0 261.6

Q11 4.8 16.2 14.8 30.8 32.2 24.6 9.2 29.4 4.8 20.3 32.2

Q12 2.2 69.7 10.5 27.6 62.7 14.0 30.1 5.5 2.2 27.8 69.7

Q13 14.7 18.3 15.4 15.7 18.5 20.9 16.4 16.3 14.7 17.0 20.9

Q14 1.2 26.9 44.2 22.9 40.3 18.4 37.2 18.7 1.2 26.2 44.2

Q15 2.1 36.6 31.4 40.7 7.3 27.8 17.5 43.5 2.1 25.9 43.5

Q16 3.0 3.5 8.0 6.4 6.9 4.6 5.0 6.5 3.0 5.5 8.0

Q17 2.4 6.3 15.7 15.4 15.2 29.9 4.4 6.2 2.4 11.9 29.9

Q18 21.8 38.2 57.5 51.4 56.4 62.7 73.5 90.2 21.8 56.5 90.2

Q19 2.3 5.3 6.9 5.0 3.4 4.8 3.7 4.7 2.3 4.5 6.9

Q20 4.1 73.0 62.5 21.9 25.1 37.7 35.2 29.3 4.1 36.1 73.0

Q21 14.3 50.1 34.0 51.4 32.4 49.6 23.9 64.9 14.3 40.1 64.9

Q22 2.3 3.7 2.5 3.6 8.6 3.6 6.3 6.2 2.3 4.6 8.6

RF1 25.4 27.1 26.3 27.2 26.6 27.6 25.2 37.8 25.2 27.9 37.8

RF2 30.1 26.0 26.6 31.3 26.8 28.4 23.5 24.0 23.5 27.1 31.3

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