Executive Summary


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

0 downloads 205 Views 402KB Size

Cisco UCS C240 M5 Server Total System Cost

TPC-H Rev. 2.17.2 TPC-Pricing Rev. 2.3.0 Report Date: 4-June-2018

Composite Query per Hour Metric

Price / Performance

1,029,593.5

$0.47 USD

$481,900.98USD

$ / QphH@3000GB QphH@3000GB

Database Size

Database Manager

Operating System

3000GB

Microsoft SQL Server 2017 Enterprise Edition for Linux

Red Hat Enterprise

Other Software

Availability Date

1-June-2018

Linux 7.3

Database Load Time = 3h 11m 31s Load Includes Backup: Y Total Data Storage / Database Size = 7.1 Percentage Memory / Database Size = 51.2% System Configuration: Processors/Cores/Threads/Model: Memory: Storage: Table Storage: TPC-H Executive Summary © 2018 Cisco Systems, Inc. All rights reserved

Storage Redundancy Level Base Tables and Auxiliary Data Structures 0 DBMS Temporary Space 0 OS and DBMS Software 1 Cisco UCS C240 M5 Server 2/56/112 Intel Xeon Platinum 8180 (2.5 GHz, 38.5MB cache) 1.5 TB 3 X 3.8TB 2.5 Inch Enterprise Value 6G SATA SSD 4 X Cisco HHHL AIC 3.2T HGST SN260 NVMe Extreme Perf High Endrnc 11.9 TB

Cisco UCS C240 M5 Server

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

TPC-H Rev. 2.17.2 TPC-Pricing Rev. 2.3.0 Report Date: 4-June-2018

Cisco UCS C240 M5 Server

TPC-H Rev. 2.17.2 TPC-Pricing Rev. 2.3.0 Report Date: 4-June-2018

Measurement Results 3,000 7.1 51.2 03/30/2018 04:20:30 03/30/2018 07:32:01 00d 03h 11m 31s 8 1,371,924.8 772,682.9 1,029,593.5 $481,900.98 $0.47

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: Query Start Time Seed Query End Time Power Run 2018-03-30 08:54:59 330073201 2018-03-30 08:59:16 Throughput Stream

Seed

1

330073202

2

330073203

3

330073204

4

330073205

5

330073206

6

330073207

7

330073208

8

330073209

Query Start Time Query End Time 2018-03-30 09:00:10 2018-03-30 09:33:12 2018-03-30 09:00:10 2018-03-30 09:32:34 2018-03-30 09:00:10 2018-03-30 09:33:12 2018-03-30 09:00:10 2018-03-30 09:32:06 2018-03-30 09:00:10 2018-03-30 09:32:46 2018-03-30 09:00:10 2018-03-30 09:32:34 2018-03-30 09:00:10 2018-03-30 09:29:20 2018-03-30 09:00:10 2018-03-30 09:32:29

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

Duration (sec) 257 Duration (sec) 1,982 1,944 1,982 1,916 1,956 1,944 1,750 1,939

2,460

RF1 Start Time RF1 End Time 2018-03-30 08:54:30 2018-03-30 08:54:56 RF1 Start Time RF1 End Time 2018-03-30 09:00:10 2018-03-30 09:04:37 2018-03-30 09:12:33 2018-03-30 09:20:39 2018-03-30 09:28:17 2018-03-30 09:32:46 2018-03-30 09:34:06 2018-03-30 09:34:34 2018-03-30 09:35:36 2018-03-30 09:36:02 2018-03-30 09:37:05 2018-03-30 09:37:32 2018-03-30 09:38:36 2018-03-30 09:39:03 2018-03-30 09:39:54 2018-03-30 09:40:20

RF2 Start Time RF2 End Time 2018-03-30 08:59:19 2018-03-30 09:00:11 RF2 Start Time RF2 End Time 2018-03-30 09:04:37 2018-03-30 09:12:32 2018-03-30 09:20:39 2018-03-30 09:28:17 2018-03-30 09:32:46 2018-03-30 09:34:06 2018-03-30 09:34:34 2018-03-30 09:35:35 2018-03-30 09:36:02 2018-03-30 09:37:05 2018-03-30 09:37:32 2018-03-30 09:38:36 2018-03-30 09:39:03 2018-03-30 09:39:54 2018-03-30 09:40:21 2018-03-30 09:41:10

TPC-H Rev. 2.17.2 TPC-Pricing Rev. 2.3.0 Report Date: 4-June-2018

Cisco UCS C240 M5 Server TPC-H Timing Intervals (in seconds) Stream ID 0 1 2 3 4 5 6 7 8 Qi Min Qi Avg Qi Max Stream ID 0 1 2 3 4 5 6 7 8 Qi Min Qi Avg Qi Max

Q1 5.6 7.4 28.3 25.0 38.2 25.3 23.4 26.1 38.8 5.6 24.2 38.8 Q13 38.5 219.5 119.6 66.1 105.7 130.6 114.5 170.4 131.7 38.5 121.8 219.5

Q2 Q3 1.0 9.2 6.6 33.0 8.2 100.9 27.8 25.1 3.3 67.1 16.0 53.8 12.3 39.2 9.0 52.5 12.3 28.2 1.0 9.2 10.7 45.4 27.8 100.9 Q14 2.0 3.0 11.2 18.2 11.5 69.6 11.6 11.2 7.2 2.0 16.2 69.6

Q4 10.0 17.6 65.9 72.0 76.3 76.1 34.4 83.9 68.9 10.0 56.1 83.9

Q15 4.1 82.8 10.1 32.0 26.5 11.8 11.8 14.2 17.5 4.1 23.4 82.8

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

Q5 11.2 89.4 37.0 73.3 66.8 72.3 71.1 81.2 90.6 11.2 65.9 90.6

Q6 Q7 Q8 Q9 Q10 0.4 6.6 8.8 30.7 6.3 14.3 45.0 203.5 147.2 113.7 32.2 133.9 175.3 137.7 117.5 21.5 51.4 97.0 211.4 142.8 5.8 48.3 153.3 213.6 97.7 13.6 41.6 164.0 129.4 74.1 9.5 38.4 89.2 153.5 72.2 14.7 53.8 87.8 243.5 59.5 13.5 38.1 86.5 120.5 136.7 0.4 6.6 8.8 30.7 6.3 13.9 50.8 118.4 154.2 91.2 32.2 133.9 203.5 243.5 142.8

Q16 Q17 14.3 4.0 93.8 41.2 100.1 64.0 57.7 90.6 127.6 36.8 172.1 34.0 100.0 91.4 32.7 28.9 93.5 116.7 14.3 4.0 88.0 56.4 172.1 116.7

Q18 41.4 315.9 282.4 341.4 299.9 304.2 509.0 268.0 520.6 41.4 320.3 520.6

Q19 1.5 52.5 59.5 161.9 96.1 32.8 100.6 132.3 55.3 1.5 76.9 161.9

Q20 6.7 66.5 49.6 60.0 39.2 43.8 54.8 61.1 40.2 6.7 46.9 66.5

Q21 28.6 240.7 258.5 235.3 294.2 240.7 231.0 153.7 211.0 28.6 210.4 294.2

Q11 14.0 33.7 23.6 29.8 23.6 30.7 33.3 39.0 32.0 14.0 28.9 39.0 Q22 8.4 27.7 35.1 49.4 35.1 58.3 80.6 50.7 14.6 8.4 40.0 80.6

Q12 3.5 125.8 93.0 91.0 49.0 160.5 61.5 74.0 63.1 3.5 80.2 160.5 RF1 26.8 266.4 486.5 268.9 27.1 26.7 26.8 27.3 26.1 26.1 131.4 486.5

RF2 52.2 474.6 457.6 79.8 61.6 62.6 63.3 50.6 49.8 49.8 150.2 474.6