SPECjAppServer2002 Result BEA WebLogic Application Server 8.1 SP2 on Sun Fire V20z Metric: 1,363.88 TOPS@MultipleNode 82.74 US$/TOPS@MultipleNode Submitter: Sun Microsystems Inc., SPEC license # 6, Test date: Aug-2004 EJB Container Avail: May-2004, EJB Container JVM Avail: Feb-2004 -------------------------------------------------------------------------------- Benchmark Settings -------------------------------------------------------------------------------- Orders Injection Rate: 800 # of Order Agents: 3 # of Manufacturing Agents: 3 DB Load Injection Rate: 800 Ramp Up Time: 600 seconds Ramp Down Time: 300 seconds Steady State Time: 1800 seconds Trigger Time: 640 seconds Total System Cost: US$112,843 -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Order Transaction Mix Count Tx. Mix New Order 707,521 49.95% Change Order 283,816 20.04% Order Status 283,370 20.01% Customer Status 141,636 10.00% Total # Order Transactions 1,416,343 Total # Manufacturing Transactions 1,038,634 Response Times Average Maximum 90th% Reqd New Order 0.66 9.03 1.90 2.00 Change Order 0.33 5.13 0.80 2.00 Order Status 0.16 4.41 0.40 2.00 Customer Status 0.16 4.28 0.40 2.00 Manufacturing 3.23 9.31 4.50 5.00 Reproducibility Run (TOPS) 1,364.83 -------------------------------------------------------------------------------- Software Descriptions -------------------------------------------------------------------------------- EJB Container Name: BEA WebLogic Server 8.1 SP2, Workgroup Edition Vendor: BEA Systems, Inc. Available: May-2004 Instances: 2 Passed CTS: May-2004 Protocol: RMI/T3 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition, Version 1.4.2_04 32-bit JVM Vendor: Sun Microsystems, Inc. JVM Available: Feb-2004 Tuning Information -Dweblogic.management.discover=false -Dweblogic.SocketReaders=1 JVM Tuning Information -server -Xms1900m -Xmx1900m -Xmn900m -XX:+UseParallelGC -XX:+UseTLAB -Xrs -XX:-UseAdaptiveSizePolicy -XX:SurvivorRatio=2 -XX:+DisableExplicitGC -XX:MaxTenuringThreshold=3 -verbose:gc -------------------------------------------------------------------------------- Supplier Domain Container Name: BEA WebLogic Server 8.1 SP2, Workgroup Edition Vendor: BEA Systems, Inc. Available: May-2004 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition, Version 1.4.2_04 32-bit JVM Vendor: Sun Microsystems, Inc JVM Available: Feb-2004 Tuning Information -Dweblogic.management.discover=false -Dweblogic.SocketReaders=1 JVM Tuning Information -server -Xms256m -Xmx256m -XX:+AggressiveHeap -verbose:gc -------------------------------------------------------------------------------- Emulator Container Name: BEA WebLogic Server 8.1 SP2, Workgroup Edition Vendor: BEA Systems, Inc. Available: May-2004 JVM Name: Java(TM) 2 Runtime Environment, Standard Edition, Version 1.4.2_04 32-bit JVM Vendor: Sun Microsystems, Inc JVM Available: May-2004 Tuning Information -Dweblogic.management.discover=false JVM Tuning Information -server -Xmx1800m -Xms1800m -Xmn768m -XX:+UseParallelGC -XX:+UseTLAB -XX:-UseAdaptiveSizePolicy -XX:SurvivorRatio=2 -XX:+DisableExplicitGC -XX:MaxTenuringThreshold=3 -Xrs -Dweblogic.SocketReaders=1 -verbose:gc -------------------------------------------------------------------------------- Database Name: MySQL Database Standard Edition 4.0.15 Vendor: MySQL Inc. Available: Dec-2003 Tuning Information db_name=specdb key_buffer = 32M max_allowed_packet = 1M table_cache = 1024 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache = 16 query_cache_size = 0 thread_concurrency = 32 max_connections=500 max_tmp_tables=64 innodb_data_home_dir = /export/databases/mysql innodb_data_file_path = ibdata1:3000M;ibdata2:20M:autoextend innodb_log_group_home_dir = /db/logs/mysql innodb_log_arch_dir = /db/specdb/mysql set-variable = innodb_log_files_in_group=2 innodb_buffer_pool_size=2G innodb_additional_mem_pool_size=20M innodb_log_file_size=1800M innodb_log_buffer_size=64M innodb_flush_log_at_trx_commit=1 innodb_lock_wait_timeout=80 innodb_thread_concurrency=1064 -------------------------------------------------------------------------------- JDBC Name: MySQL Connector/J 3.0.8 (Thin) Vendor: MySQL Inc. Available: Dec-2003 Tuning Information stmt-cache-size=300 -------------------------------------------------------------------------------- Other Software Name: Vendor: Available: Tuning Information -------------------------------------------------------------------------------- Hardware Descriptions -------------------------------------------------------------------------------- J2EE Application Server (2 systems) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire V20z Processor: AMD Opteron 250 MHz: 2400 # of CPUs: 2 cores, 2 chips, 1 core/chip Memory (MB): 4096 L1 Cache: 64KB(I)+64KB(D) per chip L2 Cache: 1MB per chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 HW 9/04 Operating System, x86 Platform Edition Disks: 1x36Gb 10K RPM Ultra-3 Network Interface: (2) 10/100/1000 BaseT Ethernet Other Hardware: # of Systems: 2 H/W Available: Jul-2004 O/S Available: Jul-2004 Notes / Tuning Information The WebLogic patch for CR133783 was applied. -------------------------------------------------------------------------------- Database Server (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire V40z Processor: AMD Opteron 850 MHz: 2400 # of CPUs: 4 cores, 4 chips, 1 core/chip Memory (MB): 8192 L1 Cache: 64KB(I)+64KB(D) per chip L2 Cache: 1MB per chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 HW 9/04 Operating System, x86 Platform Edition Disks: 2x73Gb 10K RPM Ultra-320 SCSI Network Interface: (2) onboard 10/100/1000 BaseT Ethernet Other Hardware: (1) Sun StorEdge 3310 SCSI Array (5 x 73GB 10K RPM Ultra160 SCSI) # of Systems: 1 H/W Available: Aug-2004 O/S Available: Jul-2004 Notes / Tuning Information Disk Layout: 4x73GB disks with RAID 0+1 for the log files 1x72GB disk for the data files -------------------------------------------------------------------------------- Load Driver (1 system) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Enterprise E6500 Processor: UltraSPARC II MHz: 400 MHz # of CPUs: 22 cores, 22 chips, 1 core/chip Memory (MB): 22528 L1 Cache: 32KB(I)+64KB(D) per chip L2 Cache: 1MB per chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 9 4/04 Disks: 4x36GB Network Interface: 10/100/1000 BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Aug-2003 O/S Available: Apr-2004 Notes / Tuning Information -------------------------------------------------------------------------------- Benchmark Modifications -------------------------------------------------------------------------------- Schema Modifications: Tablespace sizes were increased to support the Injection rate Scripts to create the DB are included in the FDA Two indexes were created on the M_largeorder table: CREATE UNIQUE INDEX M_lo_idx ON M_largeorder (lo_id) CREATE UNIQUE INDEX M_OL_O_idx ON M_largeorder (lo_o_id, lo_ol_id) -------------------------------------------------------------------------------- Load Program Modifications: The load program was not modified -------------------------------------------------------------------------------- Reference Bean Modifications: No changes were made to the reference beans -------------------------------------------------------------------------------- Benchmark Configuration Information -------------------------------------------------------------------------------- Persistence Mode Used: CMP mode was used for all beans -------------------------------------------------------------------------------- Isolation Requirement Info: BEAN SPEC_REQUIREMENT Deployment CORP: RuleEnt Read_Committed RC DiscountEnt Read_Committed RC CustomerEnt Read_Committed RC MFG: AssemblyEnt Read_Committed RC BomEnt Read_Committed Sel-4-Upd ComponentEnt Read_Committed RC PartEnt Read_Committed RC WorkOrderEnt Repeatable_Read Sel-4-Upd LargeOrderEnt Read_Committed RC InventoryEnt Repeatable_Read Sel-4-Upd ORDERS: OrderLineEnt Repeatable_Read Sel-4-Upd OrderCustomerEnt Read_Committed RC ItemEnt Read_Committed RC OrderEnt Repeatable_Read Sel-4-Upd SUPPLIER: SupplierEnt Read_Committed RC SupplierCompEnt Read_Committed RC SComponentEnt Repeatable_Read Sel-4-Upd POEnt Repeatable_Read Sel-4-Upd POLineEnt Repeatable_Read Sel-4-Upd Transaction consistency for those beans specifying field groups was proven by manual analysis of the source code. -------------------------------------------------------------------------------- Durability Requirement Info: The Redo log disks are mirrored (RAID 0+1). The database commits all changes to the redo log when each transaction is completed. -------------------------------------------------------------------------------- Storage Requirement Info: A 45 minute run at an injection rate of 800 increased storage by 4.40 GB. This extrapolates to 46.94 GB of storage for an 8-hour run. The database system is configured with 365 GB of storage. -------------------------------------------------------------------------------- Argument Passing Semantics: BEA WebLogic 8.1 uses pass-by-value as required by the EJB specification -------------------------------------------------------------------------------- Other Benchmark Information -------------------------------------------------------------------------------- This submission used the xerces.jar from the SPECjAppServer2002 kit. Round Robin DNS was used to balance workload over multiple WebLogic instances. The DNS server was run on one of the application server nodes -------------------------------------------------------------------------------- General Notes -------------------------------------------------------------------------------- The Audit beans were modified to use 'select count(*)' instead of 'select count (*)' queries (white space is removed after count) so that they work with MySQL. The modified source is in the FDA. No errors were reported during the final or reproducability run. -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: Sun Microsystems Inc. For other inquiries, please contact SPEC Benchmark run on Mon Aug 16 14:15:33 PDT 2004 by SPECjAppServer2002 v1.14 Result submitted on Wed Aug 18 03:03:00 EDT 2004 Report generated by SPECjAppServer2002 Reporter v1.01 Copyright (C) 2002 Standard Performance Evaluation Corporation