SPECjEnterprise®2010 Result Copyright © 2009-2010 Standard Performance Evaluation Corporation |
SAP NetWeaver CE 7.1, MaxDB 7.8 on HP DL380 G6 X5570/X5560, Novell SLES10 |
|
Submitter: HP |
SPEC license # 3 | Test date: Mar-2010 |
SUT Configuration | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||
|
Benchmark Settings | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Detailed Results | ||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
SAP Ehp1 for SAP NetWeaver CE 7.1 SP5 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SAP JVM 5.1 64-bit Patch Level 49 | ||||||
---|---|---|---|---|---|---|
|
SAP MaxDB 7.8.01.07 JDBC Driver | ||||||
---|---|---|---|---|---|---|
|
SAP MaxDB 7.8.01.10 64-Bit | ||||||
---|---|---|---|---|---|---|
|
App Server SW Configuration | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||
|
Emulator SW Configuration | ||||||||
---|---|---|---|---|---|---|---|---|
|
||||||||
|
Database SW Configuration | ||||||||
---|---|---|---|---|---|---|---|---|
|
||||||||
|
Driver SW Configuration | ||||||
---|---|---|---|---|---|---|
|
||||||
|
App Server HW (SUT hardware) | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||||
|
DB Server HW (SUT hardware) | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||||
|
Load Driver and Emulator HW (non-SUT hardware) | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||||
|
Benchmark Modifications |
---|
Schema Modifications:
Added Index on table S_PURCH_ORDER (see S_PURCH_ORDER.gdbtable in FDA/Deploy/DDIC.sda of the FDA) using the following columns - sorted ascending - in the given order: PO_SITE_ID, PO_START_DATE, PO_SUPP_ID |
Load Program Modifications:
no modifications |
Benchmark Configuration Information |
---|
Isolation Requirement Info:
The isolation level of the database connections is READ_COMMITTED - see data source descriptors data-sources.xml of FDA (FDA/Deploy/Descriptors/data-sources.xml). The SAPJPA implementation always performs JPA version checks against the database. This guarantees an isolation level of REAPEATABLE_READ where needed in the SPECjEnterprise benchmark application. The isolation level Strict REPEATABLE_READ and Strict READ_COMMITTED is achieved by disallowing Phantom Deletes on the database (database parameter UseMultiVersionReadSupport=yes). The database objects of the benchmark application are generated in the system database of the SAP Netweaver CE application server containing the tables for storing persistent JMS messages. The JMS provider uses the database connections of the application to store persistent JMS messages (see descriptor jms-resources.xml of FDA (FDA/Deploy/Descriptors/jms-resources.xml)) to meet the requirements of the Run Rules, chapter '2.10.2.1 JMS'. Please have a look at the FDA for the following configuration files which are bundled and deployed with the benchmark application archive specj.ear: data source configuration (FDA/Deploy/Descriptors/data-sources.xml) JPA descriptors (FDA/Deploy/Descriptors/persistence.xml, orm.xml) JMS configuration (FDA/Deploy/Descriptors/jms-resources.xml) E.g. the cache evict timeout of cached Item entities is 20 min by using the following configuration in the peristence.xml descriptor: com.sap.jpa.cache.query-result-cache.time-to-live=1200 |
Durability Requirement Info:
To ensure database durability, RAID10 was used for the database logs maintained on the external storage. Two RAID10 disk arrays with each a total of 4x 73.4GB disks were used for the logs. Its cache has a battery backup capable of meeting the 24 hour run requirement. |
Storage Requirement Info:
After loading the database size was 16.2GB. The >60 minute run for this submission resulted in a DB size of 17.4GB, i.e. database size increased by max. 1.2GB per 1 hour. This extrapolates to less than 16.2GB + 1.2GB*24h = 45GB for a 24 hour period. Two RAID10 disk arrays with each a total of 8x 73.4GB disks were used to create the filesystem space for the database containing 28 data files with each a size 2200MB resulting in a database size of >60GB. |
Bill of Materials |
---|
Qty Supplier, Description Product # ---- ------------------------------------------- ---------------- 2x HP DL380G6 X5560 491315-421 2x Intel Xeon Processor X5570 (2.93 GHz, 8MB L3 Cache, 95W, 500094-B21 _ DDR3-1333, HT, Turbo 2/2/3/3) 6x HP 2GB 2Rx8 PC3-10600R-9 Kit 500656-B21 4x HP 146GB 3G SAS 15K SFF DP ENT HDD 504062-B21 2x HP StorageWorks 82E 8Gb Dual-port PCI-e FC HBA AJ763A + HP Support - 3yr 24x7 U4545E 1x 10622 G2 (22U) Rack Cabinet - Shock Pallet AF022A 2x HP 7.3 kVA S132 Monitored PDU- single input, 10, 32A (INTL) AF915A 1x TFT7600 Rackmount Keyboard and Monitor INTL AG066A 1x StorageWorks 8/24 Base (16) Full Fabric Ports Enabled SAN Switch AM868A 10x HP 8Gb Short Wave B-Series FC SFP+ 1 Pack AJ716A 1x HP ProCurve Switch 3500yl-48G-PWR Intelligent Edge J8693A + HP Support - 3yr 24x7 U2856E 1x HP StorageWorks 2024 Modular Smart Array 2.5-inch Drive Bay Chassis AJ949A 2x HP StorageWorks 2300fc G2 Modular Smart Array Controller AJ798A 24x HP 72GB 3G 15K 2.5-inch SAS SFF DP HDD 418371-B21 + HP Support - 3yr 24x7 UJ675E 1x HP Novell SLES10.2 (x86_64) Media 5xCPU License SAP NetWeaver Foundation For Third Party Applications ** 7009522 + SAP MaxDB 7002719 1 SAP Enterprise Support (3 years) 7003650 ** multiplier for quadcore sockets is 2.5, i.e. 2.5 * 2 sockets = 5 CPUs |
Other Benchmark Information |
---|
DNS round robin load balancing was used and hosted on the database machine. All network connections were 1Gbps. |
General Notes |
---|
The only errors in the driver log files were those that are normally generated by this benchmark. The data sources use 'SAP Open SQL for Java'. It guarantees that all statements generated by the SAPJPA implementation can be executed by all databases which are supported by SAP and have the same semantical meaning. According to the default value of 600 for the parameter MaxSavepointTimeInterval the MaxDB database executes a savepoint at least every 10 minutes. Hence at least two database savepoints took place during the Measurement Interval. |
For questions about this result, please contact the submitter: HP For other inquiries, please contact webmaster@spec.org
Copyright © 2009-2010 Standard Performance Evaluation Corporation
First published at SPEC.org on 25-Mar-2010