0 downloads
120 Views
130KB Size
DELL PowerEdge 6800 with Oracle Database 10g R2 Total System Cost
TPC-H Composite Query per Hour
$256,383
11,742.8 QphH@300GB Database Manager Oracle Database 10g Release 2 Enterprise Edition with RAC and Partitioning
Database Size 300GB
TPC-H Revision 2.1.0 Report Date: July 08, 2005 Price/Performance
$22/QphH@300GB Operating System Red Hat Enterprise Linux Advanced Server v3.0
Other Software
Availability Date January 08, 2006
RF1 q21 q19
q17
Throughput Power
Query
q15
Geometric Mean of Power test Arithmetic Mean of Throughput test
q13 q11 q9
q7 q5 654
71 q3 q1
0.0
500.0
1000.0
1500.0
2000.0
2500.0
3000.0
Querry time in seconds
Database Load Time 4:08:19 RAID (Base tables only) N
Total Disk/Database Size 19.42 RAID (Base tables and auxiliary data structures) N
System Configuration : 2 nodes Processors (per node) : 4x 3.33GHz/1024KB L2/8MB L3 Intel Xeon MP Memory: (per node) : 16GB RAM Disk Drives: 172 – 36GB 15k HDD “Database Size includes only raw data (e.g., no temp, index, redundant storage space, etc.).”
Load Includes Backup N RAID (Everything) Y
Dell
Description
PowerEdge 6800
TPC-H EXECUTIVE SUMMARY PAGE 2 OF 2
Client/Server
Report Date: 08-Jul-05
Part Number
Third Party Brand
Server Hardware
Unit Price
Qty
Extended Price
3 yr. Maint. Price
Pricing
Dell PowerEdge 6800
221-8265
1
6,063
2
12,126
1,400
Intel Xeon MP 3.33GHz / 8MB L3 - 4 processors
311-4931
1
14,997
2
29,994
-
16 GB,DDR, 16 x 1024MB DIMMS
311-4651
1
7,498
2
14,996
-
36 GB U320M SCSI 15K RPM Hard Drive
340-1897
1
299
4
1,196
-
Crossover cable
43-425
3
2
3
5
-
Dell 15" Monitor
320-2907
1
135
2
270
-
PERC4-DC 128MB U320 SCSI RAID controller
341-1285
1
799
6
4,794
0
PERC4e-DC 128MB U320 SCSI RAID controller
341-1913
1
799
8
6,392
0
Subtotal
69,773
1,400 6,986
PowerVault Disk Subsystem PV220S, U3 SCSI, PS, Rack mount
220-4476, etc.
1
1,668
14
23,352
SCSI Cables
310-0679
1
99
14
1,386
-
36 GB U320 SCSI 15K RPM Hard Drive *
340-9371
1
249
168
41,832
-
42U Rack
220-4492
1
964
2
1,928
-
Subtotal
68,498
6,986
80,000
Server Software Oracle Database 10g Release 2, Enter. Ed.,Named User Plus, 3yrs
2
10,000
8
Partitioning, Named User Plus, 3yrs
2
2,500
8
20,000
Real Application Clusters, Named User Plus, 3yrs
2
5,000
8
40,000
Oracle Database server support package for 3yrs, per server
2
6,000
2
Oracle Mandatory E-Business Discount
2
Red Hat Enterprise Linux Advanced Server, 3yrs SUB NFI
420-4250
Notes: * Maint. included in PowerVault 220S disk pod or PV650F/630F fibre channel disk pod
1
12,000 ($22,800)
2,699
0
2
5,398
0
Subtotal
134,598
0
Other Discounts
(24,872)
-
Total 247,997 Three-Year Cost of Ownership:
8,386 $256,383
** All Microsoft maintenance is covered by the maintenance costs of Microsoft SQL Server *** 10% or minimum 2 spares are added in place of onsite service (products have a three year
QphH Rating:
11742.80
return-to-vendor warranty) Pricing: 1 - Dell 2 - Oracle 3 - Fastcomputerparts **** Discount based upon total system cost as purchased by a regular customer. Pricing may be verified by calling 1-800-BUY-DELL referencing quote numbers 230402082 as complex quotes. Audited by Lorna Livingtree, Performance Metrics Inc.
$ / QphH:
Prices used in TPC benchmarks reflect the actual prices a customer would pay for a one-time purchase of the stated components. Individually negotiated
22
DELL PowerEdge 6800 w/ Oracle 10g R2 / RHEL v3.0
TPC-H Revision 2.1.0 Report Date: July 08, 2005
Numerical Quantities Summary Measurement Results: Database Scale Factor Total Data Storage/Database Size Start of Database Load End of Database Load Database Load Time Query Streams for Throughput Test TPC-H Power TPC-H Throughput TPC-H Composite Query-per-Hour Metric (QphH@300GB) Total System Price Over 3 Years TPC-H Price Performance Metric ($/QphH@300GB)
300 19.42 06/15/2005 13:42:28 06/15/2005 17:50:47 4:08:19 6 15,189.9 9,077.9 11,742.8 $256,383 $22
Measurement Interval: Measurement Interval in Throughput Test (Ts) = 15,704.0 seconds
Duration of stream execution: Stream00 Stream01 Stream02 Stream03 Stream04 Stream05 Stream06 Refresh00 Refresh01 Refresh02 Refresh03 Refresh04 Refresh05 Refresh06
Seed 615174947 615174948 615174949 615174950 615174951 615174952 615174953
Start Date/Time 6/15/2005 18:12:13 6/15/2005 19:01:43 6/15/2005 19:01:43 6/15/2005 19:01:43 6/15/2005 19:01:43 6/15/2005 19:01:43 6/15/2005 19:01:43 6/15/2005 18:10:24 6/15/2005 19:00:56 6/15/2005 23:11:34 6/15/2005 23:13:53 6/15/2005 23:15:52 6/15/2005 23:17:38 6/15/2005 23:19:29 6/15/2005 23:21:21
End Date/Time 6/15/2005 19:00:56 6/15/2005 23:11:34 6/15/2005 23:09:55 6/15/2005 23:44:33 6/15/2005 23:55:12 6/15/2005 23:01:58 6/15/2005 23:05:00 6/15/2005 18:12:12 6/15/2005 19:01:41 6/15/2005 23:13:53 6/15/2005 23:15:52 6/15/2005 23:17:38 6/15/2005 23:19:29 6/15/2005 23:21:21 6/15/2005 23:23:27
Duration 00:48:43 4:09:51 4:08:12 3:42:50 3:53:29 4:00:15 4:03:17
0:01:48 0:00:45 0:02:19 0:01:59 0:01:46 0:01:51 0:01:52 0:02:06
DELL PowerEdge 6800 w/ Oracle 10g R2 / RHEL v3.0
TPC-H Revision 2.1.0 Report Date: July 08,2005
Numerical Quantities Summary Timing Intervals in Seconds: Query Stream00 Stream01 Stream02 Stream03 Stream04 Stream05 Stream06 Min Qi Max Qi Avg Qi
Q1 543.2 2551.2 2193.5 1645.3 2547.7 2244.7 2509.4 1645.3 2551.2 2282.0
Q2 25.7 115.7 117.9 103.6 135.0 97.7 89.8 89.8 135.0 110.0
Q3 18.0 92.1 90.7 81.7 61.4 77.2 79.3 61.4 92.1 80.4
Q4 17.0 19.6 129.2 93.7 119.7 87.3 121.8 19.6 129.2 95.2
Q5 93.1 585.7 535.3 529.5 327.7 610.1 578.3 327.7 610.1 527.8
Q6 11.6 17.6 45.1 20.5 18.4 20.2 25.3 17.6 45.1 24.5
Q7 69.9 412.9 460.0 393.8 240.2 355.6 763.4 240.2 763.4 437.7
Q8 55.8 274.1 318.4 285.5 248.0 265.6 239.3 239.3 318.4 271.8
Query Stream00 Stream01 Stream02 Stream03 Stream04 Stream05 Stream06 Min Qi Max Qi Avg Qi
Q9 282.5 1519.5 1834.4 1079.6 1656.7 983.1 1871.3 983.1 1871.3 1490.7
Q10 99.2 616.6 390.9 440.4 605.0 430.1 182.2 182.2 616.6 444.2
Q11 54.1 166.9 237.0 191.2 177.4 224.8 152.2 152.2 237.0 191.6
Q12 87.4 551.8 515.6 591.7 369.2 489.2 698.2 369.2 698.2 535.9
Q13 177.9 1022.3 1162.7 1138.4 754.4 981.7 1191.1 754.4 1191.1 1041.8
Q14 12.8 29.3 28.4 23.1 32.2 42.6 24.4 23.1 42.6 30.0
Q15 24.7 94.3 91.0 61.6 66.7 72.7 115.5 61.6 115.5 83.6
Q16 66.7 305.2 414.6 358.9 424.5 285.6 285.4 285.4 424.5 345.7
Query Stream00 Stream01 Stream02 Stream03 Stream04 Stream05 Stream06 Min Qi Max Qi Avg Qi
Q17 82.6 188.2 702.3 204.5 231.1 241.9 183.2 183.2 702.3 291.9
Q18 425.0 2260.9 2534.8 2439.8 3155.9 2959.2 2387.7 2260.9 3155.9 2623.0
Q19 156.3 387.3 291.6 950.7 311.9 304.5 380.2 291.6 950.7 437.7
Q20 45.6 166.1 302.2 201.4 125.5 198.8 171.9 125.5 302.2 194.3
Q21 525.6 3274.0 2278.5 2390.5 2239.2 3243.9 2383.2 2239.2 3274.0 2634.9
Q22 48.5 340.6 218.4 144.7 161.3 199.2 164.1 144.7 340.6 204.7
RF1 108.6 84.1 77.2 68.5 67.2 70.9 78.5 67.2 84.1 74.4
RF2 45.4 54.4 41.6 37.4 44.5 40.4 47.6 37.4 54.4 44.3