Cisco UCS C250 M2 Extended-Memory Server
TPC-H Rev. 2.14.0 TPC-Pricing Rev. 1.6.0 Report Date: February 13, 2012
Composite Query per Hour Metric
Price / Performance
331,658.1
$0.34 USD
Total System Cost
$110,951 USD
QphH@300GB
$ / QphH@300GB
Other Software
Database Size
Database Manager
Operating System
300GB
VectorWise 2.0.1
RedHat Enterprise Linux 6.0
2.9
Availability Date
February 13, 2012
39.5
RF2 RF1 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1
Geomean _____________ Arithmetic Mean -----------Throughput Power
0
25
50
75
Database Load Time = 3:45:58 Load Includes Backup: N Total Data Storage / Database Size = 3.89 Percentage Memory / Database Size = 126 System Configuration: Memory: Disk Controller Storage: Total Storage: LAN Controller
TPC-H Executive Summary © 2012 Cisco Systems, Inc. All rights reserved
100
125
150
175
200
Storage Redundancy Level Base Tables and Auxiliary Data Structures DBMS Temporary Space OS and DBMS Software Cisco UCS C250 M2 Extended-Memory Server 384 GB LSI MegaRAID SAS 9261-8i 8 x 146GB 6Gb SAS 15K RPM SFF HDD 1.17 TB 4 x Integrated 1Gb Ethernet ports
225
5 5 5
TPC-H Rev. 2.14.0
Cisco UCS C250 M2 Extended-Memory Server Description Server Hardware UCS C250 M2 Srvr w/1PSU,DVD w/o CPU, mem, HDD, or PCIe card Intel Xeon X5690 3.46GHz/6c/130W/12M/DDR3 1333MHz 16GB DDR3-1333MHz RDIMM/PC3-10600/2x8GB 2R Kit 850W power supply for the UCS C250 M2 LSI 6G MegaRAID 9261-8i card (RAID 0,1,5,6,10,60) - 512WC 146GB 6Gb SAS 15K RPM SFF HDD MS Comfort Curve DT 3000 USB-EN NA Keyboard & Mouse V173DJb LCD Monitor Cisco R42610 expansion rack C250 24x7x4Hr Onsite Support Service Large Purchase Discount i Software VectorWise 2.0 3-Y License VectorWise 2.0 1-Y Maintenance Bug Fixes Vectorwise Discount RHEL 1-2 SKT 24x7 3 Year RHN SW
Part Number
Brand
R250-2480805W A01-X0115 A02-M316GB1-2-L R250-PSU2-850W R2XX-PL003 A03-D146GA2 7ZJ-00001 ET-BV3RP-D03 RACK-UCS CON-UCS7-R250W
Cisco Cisco Cisco Cisco Cisco Cisco Provantage Provantage Cisco Cisco
Source 1 1 1 1 1 1 3 3 1 1
57.0% Cisco
1
Actian Actian 10.0% Actian Cisco
2 2 2 1
VW-3Y-GB-CISCO VW-3Y-GB-CISCO-SUP
Pricing: 1=Cisco 800-553-6387 2=Action 3=Provantage; i-For all items source 1 except support services
TPC-Pricing Rev. 1.6.0
Report Date:
Unit Price
Qty
$4,687 $4,686 $870 $560 $1,591 $561 $18 $90 $2,857 $566
1 2 24 1 1 8 1 1 1 3 Subtotal
Hardware Subtotal $250 $25
300 900
Extended Price
1 Subtotal Total
3 Year Maint. Price
$4,687 $9,372 $20,880 $560 $1,591 $4,488 $18 $90 $2,857 $44,543 -$25,390 $19,153
$1,698 $1,698 $1,698
$75,000 -$7,500
$2,349
13-Feb-2012
$67,500 $86,653
Three-Year Cost of Ownership:
$22,500 -$2,250 $2,349 $22,599 $24,297
$110,951 USD
Audited by Lorna Livingtree of Performance Metrics, Inc. 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.
QphH:
331,658.1
$ / QphH:
$0.34 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 © 2012 Cisco Systems, Inc. All rights reserved
Cisco UCS C250 M2 Extended-Memory Server
TPC-H Rev. 2.14.0 TPC-Pricing Rev. 1.6.0 February 13, 2012
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@300GB)
300 3.89 126% 12/28/11 20:35:37 12/29/11 00:21:35
3:45:58 11 376,252.7 292,349.0 331,658.1 $110,951 USD $0.34 USD
Measurement Interval Measurement Interval in Throughput Test (Ts)
894
Duration of stream execution: Seed Power Run 1229002135 Throughput Streams
Seed
1
1229002136
2
1229002137
3
1229002138
4
1229002139
5
1229002140
6
1229002141
7
1229002142
8
1229002143
9
1229002144
10
1229002145
11
1229002146
Query Start Time Query End Time 12/29/2011 04:00:23 12/29/2011 04:01:57 Query Start Time Query End Time 12/29/2011 04:02:09 12/29/2011 04:16:04 12/29/2011 04:02:09 12/29/2011 04:16:35 12/29/2011 04:02:09 12/29/2011 04:16:46 12/29/2011 04:02:09 12/29/2011 04:16:47 12/29/2011 04:02:09 12/29/2011 04:16:35 12/29/2011 04:02:09 12/29/2011 04:17:03 12/29/2011 04:02:09 12/29/2011 04:16:21 12/29/2011 04:02:09 12/29/2011 04:16:19 12/29/2011 04:02:09 12/29/2011 04:16:40 12/29/2011 04:02:09 12/29/2011 04:16:49 12/29/2011 04:02:09 12/29/2011 04:16:53
TPC-H Executive Summary © 2012 Cisco Systems, Inc. All rights reserved
Duration(sec) 94.0 Duration(sec) 835.3 866.7 877.1 878.7 866.5 894.1 851.9 849.9 871.1 880.3 884.3
RF1 Start Time RF1 End Time
RF 2 Start Time RF 2 End Time
12/29/2011 03:59:49 12/29/2011 04:00:23 RF1 Start Time RF1 End Time
12/29/2011 04:01:57 12/29/2011 04:02:05 RF 2 Start Time RF 2 End Time
12/29/2011 04:02:09 12/29/2011 04:03:03 12/29/2011 04:03:16 12/29/2011 04:03:44 12/29/2011 04:03:56 12/29/2011 04:04:24 12/29/2011 04:04:40 12/29/2011 04:05:10 12/29/2011 04:05:22 12/29/2011 04:05:50 12/29/2011 04:06:04 12/29/2011 04:06:32 12/29/2011 04:06:45 12/29/2011 04:07:15 12/29/2011 04:07:29 12/29/2011 04:08:16 12/29/2011 04:08:30 12/29/2011 04:09:01 12/29/2011 04:09:14 12/29/2011 04:09:44 12/29/2011 04:09:58 12/29/2011 04:10:28
12/29/2011 04:03:03 12/29/2011 04:03:16 12/29/2011 04:03:44 12/29/2011 04:03:56 12/29/2011 04:04:24 12/29/2011 04:04:40 12/29/2011 04:05:10 12/29/2011 04:05:22 12/29/2011 04:05:50 12/29/2011 04:06:03 12/29/2011 04:06:32 12/29/2011 04:06:45 12/29/2011 04:07:15 12/29/2011 04:07:29 12/29/2011 04:08:16 12/29/2011 04:08:30 12/29/2011 04:09:01 12/29/2011 04:09:14 12/29/2011 04:09:44 12/29/2011 04:09:58 12/29/2011 04:10:28 12/29/2011 04:10:42
TPC-H Rev. 2.14.0 TPC-Pricing Rev. 1.6.0
Cisco UCS C250 M2 Extended-Memory Server Stream ID
Q1
Q2
Q3
Q4
Q5
Q6
Q7
Q8
February 13, 2012 Q9
Q10
Q11
Q12
0 1 2 3 4 5 6 7 8 9 10 11 Minimum Maximum
5.0 60.4 64.9 69.3 58.4 60.9 61.2 90.5 75.3 59.9 74.1 74.1 5.0 90.5
0.8 6.7 6.7 4.0 4.3 4.0 4.4 5.7 4.3 9.1 5.7 4.3 0.8 9.1
0.7 5.8 3.9 1.3 3.1 3.5 16.5 3.3 7.1 3.3 4.0 5.6 0.7 16.5
0.3 2.7 2.6 4.3 2.6 3.2 3.5 3.1 3.0 2.6 2.6 3.7 0.3 4.3
3.1 28.1 25.7 23.7 34.1 22.6 19.7 25.1 27.8 20.2 5.4 29.9 3.1 34.1
0.4 5.1 0.6 4.9 6.0 5.6 4.3 4.1 3.7 5.5 2.1 3.4 0.4 6.0
2.1 26.1 21.9 28.2 22.0 25.3 28.7 22.8 32.9 21.7 25.8 19.0 2.1 32.9
2.4 21.8 27.6 31.8 21.2 20.4 27.4 23.1 23.9 33.6 17.9 32.5 2.4 33.6
18.5 161.0 217.4 225.0 229.8 163.4 224.4 209.8 220.5 162.5 159.0 187.1 18.5 229.8
5.9 35.7 35.9 21.4 22.4 19.6 36.2 21.3 21.0 25.0 20.1 31.2 5.9 36.2
1.1 13.6 6.2 6.2 6.3 12.5 12.2 14.4 5.4 14.3 5.8 10.7 1.1 14.4
1.1 16.0 11.0 11.0 15.0 11.0 11.2 12.1 14.1 12.5 16.1 14.2 1.1 16.1
Average
62.8
5.0
4.8
2.9
22.1
3.8
23.0
23.6
181.5
24.6
9.1
12.1
Stream ID 0 1 2 3 4 5 6 7 8 9 10 11 Minimum Maximum Average
Q13 18.2 142.6 89.5 115.6 104.7 132.8 126.9 87.6 104.9 130.4 140.0 118.8 18.2 142.6 109.3
Q14 2.0 10.0 14.3 10.7 19.2 16.6 10.2 9.0 15.9 10.2 9.9 25.2 2.0 25.2 12.8
Q15 1.1 10.0 9.3 7.6 10.6 9.5 9.4 6.1 9.4 7.4 11.8 4.4 1.1 11.8 8.1
TPC-H Executive Summary © 2012 Cisco Systems, Inc. All rights reserved
Q16 3.0 31.7 35.5 20.9 23.2 33.6 24.6 25.2 24.3 21.3 23.5 37.4 3.0 37.4 25.4
Q17 2.2 41.2 52.1 42.2 41.3 30.2 41.0 40.7 44.2 39.8 40.0 39.1 2.2 52.1 37.8
Q18 5.9 60.8 49.2 58.2 49.2 60.2 49.4 34.0 47.7 65.6 64.4 58.9 5.9 65.6 50.3
Q19 4.8 46.7 55.1 47.9 51.4 59.8 47.5 45.2 23.9 61.9 74.5 43.8 4.8 74.5 46.9
Q20 2.5 22.4 19.5 16.6 13.6 17.2 19.4 22.2 21.7 21.4 20.0 24.7 2.5 24.7 18.4
Q21 10.7 58.9 85.5 91.6 119.2 124.8 86.3 117.5 94.7 124.7 126.7 86.8 10.7 126.7 94.0
Q22 2.6 28.1 32.5 35.1 21.3 29.7 29.8 29.3 24.2 18.1 31.0 29.5 2.6 35.1 25.9
RF1 33.9 54.4 28.1 27.9 30.2 28.3 27.9 29.8 47.0 30.7 29.8 30.0 27.9 54.4 33.2
RF2 8.0 12.6 11.9 16.1 11.7 13.0 13.3 14.2 14.0 13.6 13.5 14.1 8.0 16.1 13.0
