La lecture en ligne est gratuite
Le téléchargement nécessite un accès à la bibliothèque YouScribe
Tout savoir sur nos offres
Télécharger Lire

PANTAmatrix TPC Benchmark H 1000GB FDR

De
4 pages
TPC-H Re v. 2.5.0PANTA Systems Report Date:PANTAmatrix October 19, 2006Total S ystem Cos t Com posite Q uery pe r H our M etric Price / P erformance59,353.9 $24.94$1,480,369.65QphH@ 1000G B $ / Q phH@ 1000G BD atabase S ize D atabase M anager Operating S ystem Other S oftware Availability D ateOracle D atabase 10g Red H at En terprise Enterprise Ed ition R elease 2 1000 GB Linux 4 Advanced None April 15, 2007with O racle R eal A pplication Server U pdate 3Clusters an d P artitioning49.4 471.9Q1Power TestQ2Q3 Throughput TestQ4Q5 Geometric Mean of Power TestQ6Q7 A rithmetic Mean of Throughput TestQ8Q9Q10Q11Q12Q13Q14Q15aQ16Q17Q18Q19Q20Q21Q22RF1RF20 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500Query times in secondsD atabase L oad T ime = 6: 07: 59 Load I ncluded B ackup: Y Total Data S torage / Database S ize = 133.0RAID (Base t ables onl y): N RAID (Base t ables a nd a uxiliary da ta s tructures): N RAID (All): NSystem C omponents System Total Per N odeNodes: 8 n.a .TMProcessor (D ual-Core AMD O pteron pr ocessor M odel 875H E2.2G Hz/1M B L 2 c ache pe r c ore f or 2M B t otal/1G Hz H yper T ransport: 32 4C ores: 64 8Threads: 64 8Memory: 256G B 32G BOS S torage (PANTA S ystems P ANTAmatrix S ystem S torage M odule): 1 n.a .OS Disk D rives (250G B 7200R PM S ATA H D D ): 14 n.a .Network I nterfaces (Infiniband 4x por ts): 32 4Storage S witch ( PANTA S ...
Voir plus Voir moins

Vous aimerez aussi

TPC-H Rev. 2.5.0 PANTA Systems Report Date: PANTAmatrix October 19, 2006 Total System CostComposite Query per Hour MetricPrice / Performance 59,353.9 $24.94 $1,480,369.65 QphH@1000GB $/ QphH@1000GB Database SizeDatabase ManagerOperating SystemOther SoftwareAvailability Date Oracle Database 10g Red Hat Enterprise Enterprise Edition Release 2 1000 GBLinux 4 AdvancedNone April15, 2007 with Oracle Real Application Server Update 3 Clusters and Partitioning 49.4 471.9 Q1 Power Test Q2 Q3 Throughput Test Q4 Q5 Geometric Mean of Power Test Q6 Q7 Arithmetic Mean of Throughput Test Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15a Q16 Q17 Q18 Q19 Q20 Q21 Q22 RF1 RF2 0 100200 300 400 500 600 700 800 9001000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 Query times in seconds Database Load Time = 6:07:59Load Included Backup: YTotal Data Storage / Database Size = 133.0 RAID (Base tables only): NRAID (Base tables and auxiliary data structures): NRAID (All): N System ComponentsSystem TotalPer Node Nodes: 8n.a. TM Processor (Dual-Core AMD Opteronprocessor Model 875HE 2.2GHz/1MB L2 cache per core for 2MB total/1GHz Hyper Transport:32 4 Cores: 648 Threads: 648 Memory: 256GB32GB OS Storage (PANTA Systems PANTAmatrix System Storage Module):1 n.a. OS Disk Drives (250GB 7200RPM SATA HDD):14 n.a. Network Interfaces (Infiniband 4x ports):32 4 Storage Switch (PANTA Systems 24-port Infiniband switch):2 n.a. Storage Switch (Silverstorm Technologies 9024 24-port Infiniband switch):2 n.a. Storage Subsystem (PANTA Systems Storage Array Module):37 n.a. Storage Subsystem Disk Drives (250GB 7200RPM SATA HDD):518 n.a. Total Storage:133,000GB n.a.
PANTA Systems PANTAmatrix – TPC Benchmark H Executive Summary © 2006 PANTA Systems Inc.All rights reserved
1
TPC-H Rev. 2.5.0 PANTA Systems Report Date: PANTAmatrix October 19, 2006 Par tExte nde d3 yr. Maint. De s cr iptionBr andPr icingUnit PriceQty Num be rPrice Price Sys te mHar dw are Compute Module; 4 x 2.2GHz DUAL CORE (Opteron 875HE) processors, NO memory, 16 available DIMM slots, dual port InfiniBand 4X, singleCPE-04248 208,000.001 26,000.0080,500.00 PCIe 8X slot 16GB MemoryKit (Kit contains 8x2GB DDR-400MHz ECC Registered MEM-0116 16,100.00 1697,600.00 DIMMs), for use with 4-socket Compute Module PANTA 8U Enclosure for Compute, Visualization, and Switch ModulesSUB-0100 15,400.00 15,400.00 PANTA Switch Module, 24 port based InfiniBand switch with 8 connections SWE-0124-A 16,300.00 212,600.00 to Compute Modules and 16 externallyaccessible connections Silv erstorm9024 (24-port InfiniBand SDR switch w/ embedded management support, sigle power supply and subnet manager key for upSWE-S124 110,100.00 220,200.00 4,600.00 to 288 nodes). PANTA 42U rack with standard front doorRCK-0100 16,700.00 320,100.00 Rack side panelsRCK-0101 10.00 10.00 42U rack rear door - standardRCK-0102 10.00 30.00 PANTA 42U Tall Rack Shipping CrateRCK-0900 10.00 30.00 3 x powercables from PANTA 8U enclosure to rack based power CBL-0001 180.00 180.00 distribution unit 16 port Gigabit Ethernet switch for PANTA management networkHUB-0001 1550.00 31,650.00 PANTA Rack mounted power distribution units (includes 2 PDU's for full PWR-0001 13,800.00 311,400.00 rack configuration, total of 4 cords, 220V 3Phase-20A) 3M Inf iniBand CableCBL-0103 1105.00 191,995.00 Ethernet Cable (RJ45 Cat-5E) 7 feet CBL-00411 5.254 21.00 2 port InfiniBand 4X HBA (PCIe based)IOE-0002 11,500.00 812,000.00 Subtotal 391,046.0085,100.00 Stor ageand Syste mM anage m e ntHardw ar e PANTAmatrix System Control Module with dual port InfiniBand 4X HBA, SCM-0210 16,800.00 16,800.00 3,840.00 and PANTA Sy s-Manager sof tware support, dual RAID controllers with battery backup, 14 externally SSM-03101 13,400.001 13,400.00 accessible drive bays (empty), battery backup, and PANTA Sys-Manager PANTA Storage ArrayModule with dual port InfiniBand 4X support, dual RAID controllers with battery backup, and 14 externally accessible drive SAM-05101 13,400.0037 495,800.00149,500.00 bay s(empty ). Sled mounted 250GB 7200 RPM SATA drive for the SCM-0210, SCE-HD3-250GB1 280.00532 148,960.00 0300, SSM-0310, and SAM-0510 3M Inf iniBand CableCBL-0103 1105.00 394,095.00 Ethernet Cable (RJ45 Cat-5E) 7 feet CBL-00411 5.2539 204.75 Subtotal 669,259.75153,340.00 Softw ar e PANTA Sys-Manager 2.0 License for up to 8 Compute ModulesPSM-0020 11,500.00 11,500.00 1,500.00 PANTA Sys-Manager Media KitPSM-0001-MK 1150.00 1150.00 Red Hat Enterprise Linux AS 4.0, Update 3, Standard Edition (single node RHAS-0001 12,500.00 820,000.00 40,000.00 license, 1yr support) Oracle Database 10g Enterprise Edition Release 2, Named User Plus for run-time Oracle2 10,000.0032 320,000.00 3 Years Oracle Real Appliaction Clusters, Named User Plus for 3 Yearsrun-time Oracle2 5,000.0032 160,000.00 Partitioning, Named User Plus for 3 Years run-timeOracle 22,500.00 3280,000.00 Database Server Support Package for 3 Years run-timeOracle 216,000.00 348,000.00 Subtotal 581,650.0089,500.00
PANTA Large Purchase and Net30 Discount Oracle MandatoryE-Business Discount
1 2
-367,926.10 -121,600.00 Total 1,152,429.65
327,940.00
Pricing: 1- PANTA Systems Direct 3-Year Cost of Ownership: $1,480,369.65 Pricing: 2- Oracle at 15% discount, Oracle pricing contact: Mary Beth Pierantoni, mary.beth.pierantoni@oracle.com, 916-315-5081. QphH Rating:59,353.9 **32 = 0.50 * 64.Explanation: For the purposes of counting the number of processors which require licensing, an AMD multicore chip with "n" cores shall be determined by multiplying "n" cores by a factor of 0.50. All discounts are based on US list prices and for similar quantities and configurations.$/QphH@1000GB: $24.94 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. Ifyou find that the stated prices are not available according to these terms please inform the TPC at pricing@tpc.org.Results independently audited by Francois Raab of InfoSizing, Inc.
PANTA Systems PANTAmatrix – TPC Benchmark H Executive Summary © 2006 PANTA Systems Inc.All rights reserved
2
PANTA Systems PANTAmatrix
Numerical Quantities
TPC-H Rev. 2.5.0
Report Date: October 19, 2006
Measurement Results Database Scale Factor= 1,000 Total Data Storage / Database Size= 133.0 Start of Database Load= 10/18/2006 18:13:18 End of Database Load= 10/19/2006 00:05:30 Database Load Time= 6:07:59 *  QueryStreams for Throughput Test= 8 TPC-H Power= 72,848.5 TPC-H Throughput= 48,359.0 TPC-H Composite Query-per-Hour Metric (QphH@1000GB)= 59,353.9 Total System Price Over 3 Years= $1,480,369.65 TPC-H Price/ Performance Metric ($/QphH@300GB)= $24.94 Measurement Intervals Measurement Interval in Throughput Test= 13,102 seconds Duration of Stream Execution RF1 Start TimeQuery Start TimeRF2 Start Time Seed RF1 End TimeQuery End TimeRF2 End Time Power Stream 10/19/06 07:21:4710/19/06 07:24:0210/19/06 07:48:39 1019000530 10/19/06 07:24:0210/19/06 07:48:3910/19/06 07:51:33
Duration 0:29:46
Throughput QueryStart TimeRF1 Start TimeRF2 Start Time Seed Duration Stream QueryEnd TimeRF1 End TimeRF2 End Time 10/19/06 07:51:3510/19/06 11:00:2510/19/06 11:01:57 11019000531 3:12:58 10/19/06 10:53:1710/19/06 11:01:5710/19/06 11:04:33 10/19/06 07:51:3510/19/06 11:04:3310/19/06 11:05:59 21019000532 3:16:55 10/19/06 10:54:2610/19/06 11:05:5910/19/06 11:08:30 10/19/06 07:51:3510/19/06 11:08:3010/19/06 11:09:53 31019000533 3:20:46 10/19/06 10:38:0310/19/06 11:09:5310/19/06 11:12:21 10/19/06 07:51:3510/19/06 11:12:2110/19/06 11:13:41 41019000534 3:24:34 10/19/06 10:30:2310/19/06 11:13:4110/19/06 11:16:09 10/19/06 07:51:3510/19/06 11:16:0910/19/06 11:17:22 51019000535 3:28:08 10/19/06 11:00:2410/19/06 11:17:2210/19/06 11:19:43 10/19/06 07:51:3510/19/06 11:19:4310/19/06 11:20:58 61019000536 3:31:49 10/19/06 10:57:2310/19/06 11:20:5810/19/06 11:23:24 10/19/06 07:51:3510/19/06 11:23:2410/19/06 11:24:33 71019000537 3:35:08 10/19/06 10:50:3010/19/06 11:24:3310/19/06 11:26:43 10/19/06 07:51:3510/19/06 11:26:4310/19/06 11:27:48 81019000538 3:38:22 10/19/06 10:12:3010/19/06 11:27:4810/19/06 11:29:57
* A backup of the database partitions is required to meet the durability requirements. The backup time (15 min. 47 sec.) was added into the elapsed load time.
PANTA Systems PANTAmatrix – TPC Benchmark H Executive Summary © 2006 PANTA Systems Inc.All rights reserved
3
Stream 0 Stream 1 Stream 2 Stream 3 Stream 4 Stream 5 Stream 6 Stream 7 Stream 8 Minimum Average Maximum
Stream 0 Stream 1 Stream 2 Stream 3 Stream 4 Stream 5 Stream 6 Stream 7 Stream 8 Minimum Average Maximum
Q1 155.5 216.7 962.2 739.5 619.3 234.3 838.2 801.3 907.8 216.7 664.9 962.2
Q13 81.1 649.6 361.1 597.1 339.7 211.9 1085.0 320.4 260.4 211.9 478.1 1085.0
PANTA Systems PANTAmatrix
TPC-H Timing Intervals (in seconds)
Q2 47.7 151.3 159.8 119.3 121.4 107.2 105.4 223.5 83.6 83.6 133.9 223.5
Q14 8.4 24.9 25.4 20.4 20.3 27.6 17.1 12.9 21.9 12.9 21.3 27.6
Q3 16.7 126.6 135.0 71.1 49.9 36.3 89.1 45.4 88.3 36.3 80.2 135.0
Q15a 37.9 924.7 128.6 153.1 243.8 170.0 854.6 212.6 920.4 128.6 451.0 924.7
Q4 10.4 24.1 95.9 45.3 119.7 72.6 26.4 114.2 52.3 24.1 68.8 119.7
Q16 28.9 446.9 176.0 623.6 159.8 307.3 829.8 98.6 120.0 98.6 345.3 829.8
Q5 54.7 283.6 213.2 211.4 253.4 378.4 355.8 198.3 617.1 198.3 313.9 617.1
Q17 44.4 227.1 539.0 184.8 245.7 110.4 175.1 222.1 218.0 110.4 240.3 539.0
Q6 10.4 31.4 21.2 32.1 44.1 31.5 78.0 29.5 30.6 21.2 37.3 78.0
Q18 208.3 1538.9 1863.1 624.6 1379.7 4059.5 818.6 1988.4 1031.3 624.6 1663.0 4059.5
Q7 67.4 852.4 529.9 637.0 249.1 647.1 228.5 718.0 311.7 228.5 521.7 852.4
Q19 45.4 156.9 175.8 221.5 243.4 681.8 136.9 170.0 304.8 136.9 261.4 681.8
PANTA Systems PANTAmatrix – TPC Benchmark H Executive Summary © 2006 PANTA Systems Inc.All rights reserved
Q8 33.9 203.1 135.8 255.9 325.4 139.3 402.4 609.6 242.8 135.8 289.3 609.6
Q20 24.2 310.1 239.6 143.9 92.1 112.5 111.3 329.2 306.6 92.1 205.7 329.2
TPC-H Rev. 2.5.0
Report Date: October 19, 2006
Q9 161.0 543.8 874.1 755.7 2341.8 271.3 1814.2 716.8 687.8 271.3 1000.7 2341.8
Q21 260.8 2961.4 3047.0 3577.5 1279.8 2903.0 1991.9 2885.5 1235.6 1235.6 2485.2 3577.5
Q10 41.3 465.3 298.5 399.4 484.7 65.9 229.0 152.6 418.8 65.9 314.3 484.7
Q22 29.2 102.0 169.6 153.6 133.2 298.3 107.5 336.5 121.0 102.0 177.7 336.5
Q11 50.3 122.8 170.6 145.1 129.9 132.8 108.8 234.0 127.0 108.8 146.3 234.0
RF1 135.5 92.9 85.2 83.2 80.2 72.6 74.3 68.4 65.5 65.5 77.8 92.9
Q12 59.5 536.5 649.0 275.2 649.2 330.0 743.9 314.7 346.8 275.2 480.7 743.9
RF2 173.3 155.9 151.5 147.4 148.2 141.5 146.6 130.3 129.0 129.0 143.8 155.9
4
Un pour Un
Permettre à tous d'accéder à la lecture
Pour chaque accès à la bibliothèque, YouScribe donne un accès à une personne dans le besoin