3351159 - AS Java performance issue by using DatabaseStatistics

You observe performance issues (like slow processing) in your functionality of in an application on top of AS Java persistence layer that uses DatabaseStatistics.

In the triggered thread dumps you can see the following relevant call stacks:

[...]
"MS Queue Worker [File_http://sap.com/xi/XI/SystemSend]" #67 prio=5 os_prio=0 cpu=308573780.00 [reset 307054860.00] ms elapsed=1522827.12 [reset 336973.85] s allocated=766727443400 B (714.07 GB) [reset 588491216416 B (548.08 GB)] defined_classes=3158
io= file i/o: 241217114/595828795 B, net i/o: 4335000199/8635370753 B, files opened:11510, socks opened:4244  [reset file i/o: 7545538/349564481 B, net i/o: 4028110997/7275412710 B, files opened:754, socks opened:1 ] 
user="" application="tc?bl?txmanager?plb" isapplicationthread="true" tid=0x00007f44e4fa7800 nid=0x1a8fa / 108794  pthread-id=139933710362368 runnable   [_thread_blocked (_call_back), stack(0x00007f44daf92000,0x00007f44db193000)] [0x00007f44db18e000] top_bci: 11
   java.lang.Thread.State: RUNNABLE
            at com.sap.sql.statistics.DatabaseStatistics.getOrCreateDataSourceStatistics(Ljava/lang/String;)Lcom/sap/sql/statistics/DataSourceStatistics;(DatabaseStatistics.java:220)
            at com.sap.sql.statistics.DatabaseStatistics.recordNext(Ljava/lang/String;Lcom/sap/sql/statistics/StatementStatistics;JZ)V(DatabaseStatistics.java:454)
            at com.sap.sql.statistics.impl.DatabaseStatisticsManager.recordNext(Lcom/sap/sql/statistics/StatementStatistics;ZLcom/sap/sql/statistics/impl/StatisticsRecord;)V(DatabaseStatisticsManager.java:953)
            at com.sap.sql.jdbc.common.CommonResultSet.next()Z(CommonResultSet.java:553)
            at com.sap.sql.jdbc.common.CommonResultSetForUpdate.<init>(Lcom/sap/sql/jdbc/common/AbstractCommonStatement;Ljava/sql/ResultSet;Lcom/sap/sql/jdbc/common/CommonResultSetMetaData;Z[Ljava/lang/String;)V(CommonResultSetForUpdate.java:58)
            at com.sap.sql.jdbc.common.CommonPreparedStatement.executeQuery()Ljava/sql/ResultSet;(CommonPreparedStatement.java:270)
            at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeQuery()Ljava/sql/ResultSet;(PreparedStatementWrapper.java:379)
[...]

[...]
"MS Queue Worker [File_http://sap.com/xi/XI/SystemSend]" #67 prio=5 os_prio=0 cpu=308553920.00 [reset 307035000.00] ms elapsed=1522805.99 [reset 336952.72] s allocated=766707624776 B (714.05 GB) [reset 588471397792 B (548.06 GB)] defined_classes=3158
io= file i/o: 241216794/595817515 B, net i/o: 4334861150/8635131221 B, files opened:11509, socks opened:4244  [reset file i/o: 7545218/349553201 B, net i/o: 4027971948/7275173178 B, files opened:753, socks opened:1 ] 
user="" application="tc?bl?txmanager?plb" isapplicationthread="true" tid=0x00007f44e4fa7800 nid=0x1a8fa / 108794  pthread-id=139933710362368 runnable   [_thread_blocked (_call_back), stack(0x00007f44daf92000,0x00007f44db193000)] [0x00007f44db18e000] top_bci: 11
   java.lang.Thread.State: RUNNABLE
            at com.sap.sql.statistics.DatabaseStatistics.recordPrepareStatement(Ljava/lang/String;Lcom/sap/sql/statistics/StatementStatistics;ZZJ)V(DatabaseStatistics.java:306)
            at com.sap.sql.statistics.impl.DatabaseStatisticsManager.recordPrepareStatement(Lcom/sap/sql/statistics/StatementStatistics;ZZLcom/sap/sql/statistics/impl/StatisticsRecord;)V(DatabaseStatisticsManager.java:670)
            at com.sap.sql.jdbc.common.CommonConnectionImpl.prepare(Ljava/lang/String;Lcom/sap/sql/tree/SQLStatement;)Ljava/sql/PreparedStatement;(CommonConnectionImpl.java:1672)
            at com.sap.sql.jdbc.common.CommonConnectionImpl.prepareStatement(Ljava/lang/String;)Ljava/sql/PreparedStatement;(CommonConnectionImpl.java:281)
            at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(Ljava/lang/String;)Ljava/sql/PreparedStatement;(ConnectionHandle.java:115)
[...]

SAP NetWeaver Application Server Java

databasestatistics sql property propertysheet property sheet null databasestatisticsmanager statistics database manager , KBA , BC-JAS-PER-SQL , Relational Persistence: Open SQLJ, Open JDBC , BC-XI-CON-MSG , Messaging System , Problem