TPC-H Rev 1.3.0
WorldMark 5250 Using Teradata V2R4.1 Total System Cost
Report Date: October 9, 2001
Composite Query Per Hour Rating
$ 18,605,202
Price/Performance
18,803.6
$989
QphH@3000GB Database Manager Operating System Teradata V2R4.1 UNIX MP-RAS 3.02.00
Database Size 3000GB
per QphH@3000GB Other Software Availability Date None 07-27-01
Query Time in Seconds 0
1000
2000
3000
4000
5000
6000
7000
8000
RF2 RF1 543.1
3863.8
Q1 Q2 Q3 Q4 Q5 Q6
Power Test Throughput Test
Q7 Q8 Q9 Q10 Q11 Q12 Q13
- - Geometric Mean of Power Test --- Arithmetic Mean of Throughput Test
Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21 Q22
Database Load Time = 20Hrs 23 Mins Load included backup: N Total Data Storage / Database Size = 7.34 RAID (base tables): Y RAID (Base tables & Auxiliary Data Structures) = Y RAID (All): Y System Configuration Processors: Memory (per node): Disk Drives (per node):
32 x 4 Intel Pentium III Xeon 700 MHz CPUs 1 MB Cache 2 GB Memory 2 Quad Ultra SCSI Adapters 2 9GB internal drives on 9 nodes , 1 9GB internal drive on the other 22 nodes, 3 9GB internal drives on 1 node 1 WES Modular Array with 40 x 18 GB 10K RPM drives (40 drives/node) BYNET interconnect support with 2 64-port BYNET switches Total GB of Storage = 22019.4 GB * Database size includes only raw data (e.g. no temp, index, redundant storage space, etc.) TPC-H 3000 GB NCR/Teradata Executive Summary
i
TPC-H Rev. 1.3.0 Report Date: October 9, 2001
NCR 5250 Teradata DBS V2R4.1 PRODUCT ID
DESCRIPTION
QTY
EXT PRICE
5 -YR MAINT
Server Hardware 9100-5242-8090
WM5250 SYSTEM CAB W/BYNET V2-16 NODE SWITCH - 700 MHZ
1
$361,350
$99,000
9100-5240-8090
WM5250 DUAL NODE EXPANSION CABINET - 700 MHZ
15
$5,420,250
$1,485,000
9102-5201-8090 9100-F118
64 NODES BYNET SWITCH CABINET MEMORY DIMM 1GB EDO (4X256)
2 32
$0 $256,960
$224,000 $0
9100-F283
ADAPTER - PCI HPPQS 80MB/SEC
64
$151,840
$0
3484-1007-8090
S24,2X550AWS,12+ NODES
1
$10,731
$2,940
3498-2294-8090 9100-F430
MONITOR 21IN COL .25,TCO95 TAPE- 8MM 2X 7/14GB
1 1
$948 $2,070
$260 $567
3484-F050
POWER CORD- US
1
$18
$0
3484-F700
KEYBOARD (US ENGLISH) INTL
1
$37
$0
3484-F730 1428-C001-0010
MODEM- EXTERNAL 28.8 USA POWER CORD, USA (UL/CSA)
1 1
$164 $4
$0 $0
9100-F807
NCR UNIX MP-RAS NFS PRELOAD
16
$0
$0
9100-K933 9100-K936
CABLE & TERMINATORS - BYNET V2 4800/5200 PANELS,STABALIZERS,MANUALS
16 1
$29,200 $1,095
$0 $0
Server Subtotal
$
6,234,666
$
1,811,767
Storage Devices 6000-9122-8090 6288-1440-8900
WORLDMARK ENTERPRISE STORAGE CABINET QUAD MODULAR ARRAY 1440
6288-F201
DUAL ENTERPRISE CONTROLLER W/32MB CACHE
6288-F428
QU (4) 18GB 10K RPM DISK DRIVE
6000-F248 6000-K930 9100-K930
16 32
$843,427 $1,097,600
$150,612 $196,000
32
$1,008,000
$0
320
$2,150,400
$0
INSTALL FEATURE 6288-1440 QUAD NSC/WES ACCESSORIES KIT
32 2
$0 $0
$0 $0
CABLES FOR ADAPTER - PCI HPPQS
64
Storage Devices Subtotal
$116,480 $
5,215,907
$0 $
346,612
Software Licenses F601-7730-0000
SW;EOE/MPP 8 NODES
4
$75,000
$50,000
F601-7811-0000
SW;OLTP AWS OP ENV FOR S26/S40
1
$3,000
$2,000
F7A4-1010-0000
TERADATA FASTLOAD FOR MPP UNIX NODE LICENSE
1
$7,500
$5,000
F7A4-0970-0000 F7A4-0990-0000
TERADATA BTEQ FOR MPP UNIX NODE LICENSE TERADATA CLI FOR MPP UNIX NODE LICENSE
1 1
$3,000 $3,000
$2,000 $2,000
F784-1757-0000
TERADATA/DB V2R4.1 WM 5250 MP-RAS 0 - 3 TB OF USER DATA LICENSE
1
$2,906,250
$1,937,500
Software Subtotal
$
2,997,750
$
1,998,500
TOTAL
$
14,448,324
$
4,156,879
5-YEAR COST OF OWNERSHIP QphH@3000GB
$
18,605,202 18,804
$/QphH@3000GB
$
989
"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 the TPC at
[email protected]. Thank you." Audited by:
Francois Raab InfoSizing (www.sizing.com)
TPC-H 3000 GB NCR/Teradata Executive Summary
2
WorldMark 5250 Teradata DBS V2R4.1
TPC-H Rev. 1.3.0 Report Date: October 9, 2001
Numerical Quantity Summary Measurement Results: Database Scale Factor Total Data Storage / Database Size Start of Database Load Time End of Database Load Time Database Load Time Query Streams for Throughput Test TPC-H Power TPC-H Throughput Composite QphH@1000GB Total System Price Over 5 Years TPC-H Price/Performance Metric
= =
= = = = = = =
3000 7.34 10-27-00 18:37:33 10-28-00 14:59:46 20 hrs. 23 min. 8 19,884.7 17,781.3 18,803.6 $18,605,202 $989
Measurement Intervals:
Measurement Interval in Throughput Test (Ts) = 106,899 seconds
Duration of stream execution: StreamID Seed
Start Date 1028145946 10/30/00 1028145947 10/30/00 1028145948 10/30/00 1028145949 10/30/00 1028145950 10/30/00 1028145951 10/30/00 1028145952 10/30/00 1028145953 10/30/00 1028145954 10/30/00 10/30/00
Start Time End Date End Time Duration
Stream00 Stream01 Stream02 Stream03 Stream04 Stream05 Stream06 Stream07 Stream08 Refresh
17:30:52 21:55:36 21:55:36 21:55:36 21:55:36 21:55:36 21:55:36 21:55:36 21:55:36 21:55:36
TPC-H 3000 GB NCR/Teradata Executive Summary
10/30/00 10/31/00 10/31/00 10/31/00 10/31/00 10/31/00 10/31/00 10/31/00 10/31/00 11/01/00
21:55:36 23:01:29 17:33:55 22:24:21 23:10:28 22:01:25 23:36:30 18:27:42 22:02:45 03:37:15
04:24:44 25:05:53 19:38:19 24:28:45 25:14:52 24:05:49 25:40:54 20:32:06 24:07:09 29:41:39
3
WorldMark 5250 Teradata DBS V2R4.1
TPC-H Rev. 1.3.0 Report Date: October 9, 2001
TPC-H Timing Intervals Query Stream0 Stream01 Stream02 Stream03 Stream04 Stream05 Stream06 Stream07 Stream08
Q1 752.2 1202.9 3657.7 3977.3 1777.0 5123.2 3226.1 2528.4 2760.0
Q2 62.9 455.9 1203.6 445.0 534.7 641.3 1447.1 1017.0 433.2
Q3 Q4 824.3 567.1 7288.4 1981.6 3395.4 3581.6 4160.3 5625.7 2466.0 9369.3 4600.3 6598.5 7436.9 10410.4 3074.1 2207.9 3734.9 9327.3
Q5 890.3 3768.2 4224.0 6267.3 5758.6 5210.4 6893.5 4434.3 4989.0
Q6 431.9 5088.3 4884.6 6482.8 2365.9 3772.4 4900.9 5403.6 5283.4
Q7 723.5 2756.8 3135.6 3102.9 4779.4 2949.0 6091.5 3932.4 3523.3
Q8 389.2 2685.0 4604.2 5749.7 6324.3 5209.2 3318.6 4626.0 3500.7
Min Qi Max Qi Avg Qi
1202.9 5123.2 3031.6
433.2 1447.1 772.2
2466.0 1981.6 7436.9 10410.4 4519.5 6137.8
3768.2 6893.5 5193.2
2365.9 6482.8 4772.7
2756.8 6091.5 3783.9
2685.0 6324.3 4502.2
Query Stream0 Stream01 Stream02 Stream03 Stream04 Stream05 Stream06 Stream07 Stream08
Q9 1182.4 7316.2 5465.3 9004.8 7645.7 6939.0 6818.7 6520.0 6615.8
Q10 598.5 9063.1 1828.8 2971.1 3933.0 2638.9 5530.8 3116.8 3957.0
Q11 486.9 2233.0 2650.8 2575.4 4063.9 2850.1 2663.1 2586.0 2260.9
Q12 566.6 9744.2 2166.8 2221.6 9358.9 3285.3 8390.1 1775.1 9103.5
Q13 1033.6 4017.2 3787.4 4456.5 3012.9 3537.4 2246.9 3141.7 4515.5
Q14 502.1 3984.5 2125.8 1799.6 2754.3 3837.6 1655.9 1744.1 2176.6
Q15 525.9 4275.1 2369.9 6424.6 6752.9 3019.9 4430.2 2992.6 2104.7
Q16 360.3 2422.1 2567.1 4037.4 1850.2 2212.8 3003.8 4146.4 2742.2
Min Qi Max Qi Avg Qi
5465.3 9004.8 7040.7
1828.8 9063.1 4129.9
2233.0 4063.9 2735.4
1775.1 9744.2 5755.7
2246.9 4515.5 3589.5
1655.9 3984.5 2509.8
2104.7 6752.9 4046.2
1850.2 4146.4 2872.7
Query Stream0 Stream01 Stream02 Stream03 Stream04 Stream05 Stream06 Stream07 Stream08
Q17 372.2 3565.4 3434.2 3413.4 3328.0 4637.9 629.0 2866.0 3002.1
Q18 741.2 7170.9 2663.2 4157.2 3263.6 6765.4 6662.9 5878.2 2742.9
Q19 496.4 2647.3 4012.3 2719.9 3668.6 3510.6 2171.1 3906.9 4857.0
Q20 1228.7 2810.2 4045.3 2743.2 2329.9 3132.3 2795.3 3369.3 4092.6
Q21 1302.2 5746.3 4324.8 5391.4 5327.3 5882.4 1299.7 4090.1 3857.7
Q22 56.0 131.0 570.7 398.7 227.3 395.0 432.0 569.4 1248.5
RF1 719.6 720.2 714.7 713.8 720.1 713.1 712.6 711.8 718.1
RF2 1069.7 1108.3 1120.5 1110.2 1093.0 1075.8 1073.2 1031.4 1108.1
Min Qi Max Qi Avg Qi
629.0 4637.9 3109.5
2663.2 7170.9 4913.0
2171.1 4857.0 3436.7
2329.9 4092.6 3164.8
1299.7 5882.4 4490.0
131.0 1248.5 496.6
711.8 720.2 715.5
1031.4 1120.5 1090.1
TPC-H 3000 GB NCR/Teradata Executive Summary
4