-------------------------------------------------------------------------------- SPECjAppServer(R)2004 Result Copyright (C) 2004 Standard Performance Evaluation Corporation -------------------------------------------------------------------------------- Sun Java System Application Server Platform Edition 8.1 2005Q1 UR1 on V20z Cluster -------------------------------------------------------------------------------- NON-COMPLIANT (NC) RESULT -------------------------------------------------------------------------------- Submitter: Sun Microsystems Inc. SPEC license # 6 Test date: Jul-2005 -------------------------------------------------------------------------------- SPEC has determined that this result was not in compliance with the SPECjAppServer2004 run and reporting rules. Specifically, this result used a configuration which SPEC has determined is not in compliance with section 2.10.1 of the benchmark run rules and hence violates SPECjAppServer2004's atomicity requirements. -------------------------------------------------------------------------------- SUT CONFIGURATION -------------------------------------------------------------------------------- J2EE Server Nodes: 3 DB Server Nodes: 1 J2EE Server CPUs: 6 cores, 6 chips (1 core/chip) DB Server CPUs: 2 cores, 2 chips (1 core/chip) J2EE Instances: 3 DB Instances: 1 Other SUT Components: (1) Cisco Catalyst 3500 Series XL 8 Port 10/100/1000 Switch -------------------------------------------------------------------------------- BENCHMARK SETTINGS -------------------------------------------------------------------------------- Dealer Injection Rate: 160 Ramp Up Time: 600 sec # of Dealer Agents: 2 Ramp Down Time: 300 sec # of Manufacturing Agents: 2 Steady State Time: 3,600 sec DB Load Injection Rate: 160 Trigger Time: 90 sec -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Dealer Transaction Mix Count Tx. Mix Purchase 144,246 24.98% Manage 144,143 24.96% Browse 289,073 50.06% Total # Dealer Transactions 577,462 Total # Manufacturing Transactions 380,167 Response Times Average Maximum 90th% Reqd Purchase 0.23 35.57 0.50 2.00 Manage 0.41 32.18 0.90 2.00 Browse 0.24 45.83 0.30 2.00 Manufacturing 2.09 23.34 4.00 5.00 Reproducibility Run (SPECjAppServer2004 JOPS) 266.31 -------------------------------------------------------------------------------- SOFTWARE PRODUCTS -------------------------------------------------------------------------------- Sun Java System Application Server Platform Edition 8.1 2005Q1 UR1 Vendor: Sun Microsystems, Inc. Availability Date: Mar-2005 Date Passed CTS: Feb-2005 CTS Version: 1.4 EJB Protocol: RMI/IIOP OS Name: Solaris 10 64-bit -------------------------------------------------------------------------------- Jakarta Tomcat 4.1.31 Vendor: Apache Software Foundation Availability Date: Oct-2004 -------------------------------------------------------------------------------- Java (TM) 2 Platform Standard Edition Development Kit 5.0 Update 5 32-bit Vendor: Sun Microsystems, Inc. Availability Date: Sep-2005 OS Name: Solaris 10 64-bit -------------------------------------------------------------------------------- Java (TM) 2 Platform Standard Edition Development Kit 5.0 Update 3 32-bit Vendor: Sun Microsystems, Inc. Availability Date: Apr-2005 OS Name: Solaris 10 64-bit -------------------------------------------------------------------------------- MySQL Connector/J 3.1.9 Vendor: MySQL Corporation Availability Date: Jun-2005 OS Name: Solaris 10 64-bit -------------------------------------------------------------------------------- MySQL 5.0.4 64-bit Vendor: MySQL Corporation Availability Date: Sep-2005 OS Name: Solaris 10 64-bit -------------------------------------------------------------------------------- SOFTWARE CONFIGURATIONS -------------------------------------------------------------------------------- J2EE Application Servers J2EE Product: Sun Java System Application Server Platform Edition 8.1 2005Q1 UR1 JVM Product: Java (TM) 2 Platform Standard Edition Development Kit 5.0 Update 5 32-bit JDBC Product: MySQL Connector/J 3.1.9 Hardware: J2EE AppServer HW # of Instances: 3 Interfaces: Web Interface for the Dealer Domain Web Interface for the Supplier Domain EJB Interface for the Dealer Domain EJB Interface for the Manufacturing Domain EJB Interface for the Supplier Domain Notes / Tuning Information Tunings in domain.xml: JVM Options: -server -Xmx1300m -Xms1300m -XX:NewRatio=2 -XX:+AggressiveHeap -XX:LargePageSizeInBytes=2m -Xss128k -Dcom.sun.enterprise.web.connector.grizzly.socketSoTimeout=7200000 -Dcom.sun.enterprise.web.connector.grizzly.singlethread=false -Dcom.sun.enterprise.web.connector.grizzly.maxReadWorkerThread=15 -Dcom.sun.enterprise.web.connector.grizzly.keepAlive=7200 -Dcom.sun.enterprise.web.connector.grizzly.pools.size=500 -Dcom.sun.enterprise.web.connector.grizzly.maxAcceptWorkerThread=10 -XX:+DisableExplicitGC Disable security manager by remove reference to the server.policy file. JDBC Pool: max-pool-size=80, steady-pool-size=80 JDBC: cachePrepStmts=true prepStmtCacheSize=512 JDBC: useServerPrepStmts=false alwaysSendSetIsolation=false JDBC: useLocalSessionState=true elideSetAutoCommit=true JDBC: useUsageAdvisor=false useReadAheadInput=false JDBC: useUnbufferedInput=false HTTP Listener: acceptor-threads=700 HTTP: accessLoggingEnabled=false ORB: ThreadPool: max-thread-pool-size=60, min-thread-pool-size=60 JMS: ConnectionPool: max-pool-size=250 MDB Container: max-pool-size=256, steady-pool-size=25 Tunings in default-web.xml: development=false, genStrAsCharArray=true General Tunings: All application servers run in FX class via priocntl command -------------------------------------------------------------------------------- Emulator SW Config JVM Product: Java (TM) 2 Platform Standard Edition Development Kit 5.0 Update 3 32-bit Web Product: Jakarta Tomcat 4.1.31 Hardware: Load Driver HW # of Instances: 1 Notes / Tuning Information JVM Options: -server -Xmx2048m -Xms2048m -Xss128k -Dsun.net.inetaddr.ttl=0 -Dnetworkaddress.cache.ttl=0 server.xml: maxProcessors=1600 -------------------------------------------------------------------------------- Database SW Config DB Product: MySQL 5.0.4 64-bit Hardware: Database Server HW # of Instances: 1 Notes / Tuning Information MySQL 5.0 Tuning in /etc/my.cnf [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = READ-COMMITTED datadir=/SPECDB/mysql5-64/var port = 3306 skip-locking max_allowed_packet = 1M max_connections=500 table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_type = 0 thread_concurrency = 4 server-id = 1 innodb_data_home_dir = /SPECDB/mysql5-64/var innodb_data_file_path = ibdata1:5000M:autoextend innodb_log_group_home_dir = /SPECDB/mysql5-64/var/ innodb_log_arch_dir = /SPECDB/mysql5-64/var/ innodb_checksums = 0 innodb_buffer_pool_size = 1800m innodb_additional_mem_pool_size = 20M innodb_log_file_size = 700M innodb_log_buffer_size = 64M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 1000 innodb_locks_unsafe_for_binlog = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout -------------------------------------------------------------------------------- Driver SW Config Primary JVM Product: Java (TM) 2 Platform Standard Edition Development Kit 5.0 Update 3 32-bit Hardware: Load Driver HW # of Instances: 1 Notes / Tuning Information JVM Options: -server -XX:+DisableExplicitGC -Xmx2048m -Xss128k -Dnetworkaddress.cache.ttl=0 -Dsun.net.inetaddr.ttl=0 -------------------------------------------------------------------------------- HARDWARE SYSTEMS -------------------------------------------------------------------------------- J2EE AppServer HW (SUT hardware) 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) L2 Cache: 1MB per chip Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 10 64-bit Disks: 2x73Gb 10K RPM Ultra320 SCSI Network Interface: (2) 1000BaseT Ethernet Other Hardware: # of Systems: 3 H/W Available: Mar-2005 O/S Available: Mar-2005 Notes / Tuning Information -------------------------------------------------------------------------------- Database Server HW (SUT hardware) 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) L2 Cache: 1MB Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 10 64-bit Disks: 1x73Gb 10K RPM Ultra320 SCSI Network Interface: (2) Onboard 1000BaseT Ethernet Other Hardware: Sun StorEdge SE3310 Array (12 x 73GB UltraSCSI Disk Array) # of Systems: 1 H/W Available: Mar-2005 O/S Available: Mar-2005 Notes / Tuning Information System Tuning in /etc/system: set shmsys:shminfo_shmmax=0x1ffffffff UFS options for /SPECDB: noatime Solaris Patch 119375-02 was applied. -------------------------------------------------------------------------------- Load Driver HW (non-SUT hardware) Hardware Vendor: Sun Microsystems, Inc. Model Name: Sun Fire V440 Processor: UltraSPARC IIIi MHz: 1280 # of CPUs: 4 cores, 4 chips, 1 core/chip Memory (MB): 16384 L1 Cache: 32KB(I)+64KB(D) L2 Cache: 1MB Other Cache: OS Vendor: Sun Microsystems, Inc. OS Name: Solaris 10 64-bit Disks: 4 x 36GB Network Interface: (2) Onboard 1000BaseT Ethernet Other Hardware: # of Systems: 1 H/W Available: Aug-2003 O/S Available: Mar-2005 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 BENCHMARK CONFIGURATION INFORMATION -------------------------------------------------------------------------------- Isolation Requirement Info: BEAN SPEC_REQUIREMENT Deployment Corp.CustomerEnt Repeatable Read Sel-4-Upd Corp.CustomerInventoryEnt Repeatable Read Sel-4-Upd Mfg.InventoryEnt Repeatable Read Sel-4-Upd Mfg.WorkOrderEnt Repeatable Read Sel-4-Upd Orders.OrderEnt Repeatable Read Sel-4-Upd Orders.OrderLineEnt Repeatable Read Sel-4-Upd Supplier.POEnt Repeatable Read Sel-4-Upd Supplier.POLineEnt Repeatable Read Sel-4-Upd Supplier.SComponentEnt Repeatable Read Sel-4-Upd Util.SequenceEnt Repeatable Read Sel-4-Upd Mfg.AssemblyEnt Read Committed RC Mfg.BomEnt Read Committed RC Mfg.ComponentEnt Read Committed RC Mfg.LargeOrderEnt Read Committed RC Mfg.PartEnt Read Committed RC Orders.ItemEnt Read Committed RC Supplier.SupplierCompEnt Read Committed RC Supplier.SupplierEnt Read Committed RC The ItemEnt bean was cached for 20 minute intervals by setting is-read-only-bean=true and refresh-period-in-seconds=1200 in the sun-orders.xml deployment descriptor. Only the data inside the bean was cached. -------------------------------------------------------------------------------- Durability Requirement Info: To ensure database durability, RAID 1 (mirror disks) was used for the database files and logs maintained on the Sun StorEdge 3310 Array. Each application server has a pair of mirrored disks (using Solaris raidctl utility) to provide durability for the XA transaction logs, message queues, and message logs. -------------------------------------------------------------------------------- Storage Requirement Info: A 75 minute run at an injection rate of 160 increased storage by 118.34 MB This extrapolates to 2.21 GB of storage for a 24 hour run. The Sun StorEdge 3310 Array utilized 10 drives in a RAID 1 logical drive for a total of 340 GB of available storage. -------------------------------------------------------------------------------- Argument Passing Semantics: Sun Java System Application Server 8.1 uses pass-by-value semantics by default. BILL OF MATERIALS -------------------------------------------------------------------------------- Supplier Description Product # Qty -------- ---------------------------------------- ------------------ --- Sun Sun Fire V20z, 2x2.4 GHz, 4 GB mem A55-NZB2-1-4GRA5L 3 Sun 73 GB Ultra320 SCSI Disk 9256A 3 Sun Solaris 10 Media KIT SOLZ9-100C9A7M 1 Sun SunSpectrum Upgrade: 3YGOLD, 24x7 W9D-A55-24-3G 3 Sun Sun Fire V20z, 2x2.4 GHz, 4 GB mem A55-NZB2-1-4GRA5L 1 Sun Ultra320 SCSI Dual Channel Adapter X9265A 1 Sun SunSpectrum Upgrade: 3YGOLD, 24x7 W9D-A55-24-3G 1 Sun Sun StorEdge 3310, 12 x 73 GB, 1 RAID XTA3310R01A1V876 1 Sun SunSpectum Upgrade: 3Y GOLD, 24x7 W9D-SE3310-24-3G 1 Sun 17" Entry Color Monitor X7147A 1 Sun PS/2 Keyboard & Mouse #320-1261 1 CDW Cisco Catalyst 3508G XL 10/100/1000 184837 1 CDW 1 Year Service Warranty (24x7x4) 150984 3 Sun Sun Java System Application Server SJSAS-LCO-PE8F 6 Platform Edition 8.1 2005Q1 UR1 License per CPU Sun Sun Java System Application Server SAPNS-JAM9-1PR 18 Platform Edition 8.1 2005Q1 UR1 Premium Support per CPU for 1 year MySQL MySQL Database 5.0 1 MySQL MySQL Network Gold Support 3 for 1 year -------------------------------------------------------------------------------- OTHER BENCHMARK INFORMATION -------------------------------------------------------------------------------- The submission used round-robin DNS for load-balance of all HTTP network requests. The DNS server was hosted on one of the application servers. The submission used multiple URLs to establish connections to the EJB tier using RMI/IIOP. This submission used the xerces implementation 2.6.2 provided with the Sun Java System Application Server 8.1. The emulator used xerces implementation 2.5.0 provided with the Jakarta Tomcat 4.1.31. -------------------------------------------------------------------------------- General Notes -------------------------------------------------------------------------------- The only errors in the driver log files were those that are normally generated by this benchmark. The MySQL Connector/J JDBC Driver is a type 4 driver. XA 2-phase transactions were used to coordinate the interaction between the database server and JMS server. Database checkpoints during the Measurement Interval were done by using continuous checkpoints, where MySQL database engine InnoDB flushes modified database pages from the buffer pool in small batches. The Cisco Catalyst 3508 switch used default settings. -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: Sun Microsystems Inc. For other inquiries, please contact SPEC - Benchmark run on Fri Jul 01 06:09:30 EDT 2005 by SPECjAppServer2004 v1.05 - Result submitted on Wed Jul 6 03:03:00 EDT 2005 - Report generated by SPECjAppServer2004 Reporter v1.03 Copyright (C) 2004 Standard Performance Evaluation Corporation