Symptom
- SMON/SM50/SM66 data from an ABAP Netweaver system reveals many dialog work process transactions are consumed on the database layer on a HDB HANA Database :
5 DIA Running 0 0000-xxxxxxx Medium CL_SQL_STATEMENT==============CP 1 0,0 6313 7.720 SAPMSSY1 DB Procedure DB-PROC SYS.TREXviaDBSL 0 0 0 0 RFC RSDRP_EXECUTE_AT_QUERY_RFC
17 DIA Running 0 0000-xxxxxxx High SAPLSENA 6 0,0 10502 62.023 SAPMHTTP 6 918 24 13 URL /sap/bw/ina/GetResponse
26 DIA Running 0 0000-xxxxxxx Medium CL_SQL_STATEMENT==============CP 1 0,0 18370 7.722 SAPMSSY1 DB Procedure DB-PROC SYS.TREXviaDBSL 0 0 0 0 RFC RSDRP_EXECUTE_AT_QUERY_RFC
29 DIA Running 0 0000-xxxxxxx High CL_SQL_STATEMENT==============CP 6 0,0 21236 61.905 SAPMHTTP Sequential Read 17 1.791 23 18 URL /sap/bw/ina/GetResponse
30 DIA Running 0 0000-xxxxxxx Medium CL_SQL_STATEMENT==============CP 1 0,0 21842 7.724 SAPMSSY1 DB Procedure DB-PROC SYS.TREXviaDBSL 0 0 0 0 RFC RSDRP_EXECUTE_AT_QUERY_RFC
36 DIA Running 0 0000-xxxxxxx High CL_SQL_STATEMENT==============CP 6 0,0 28047 61.913 SAPMHTTP DB Procedure DB-PROC SYS.TREXviaDBSL 0 0 0 0 URL /sap/bw/ina/GetResponse
44 DIA Running 0 0000-xxxxxxx Medium CL_SQL_STATEMENT==============CP 1 0,0 26026 7.726 SAPMSSY1 DB Procedure DB-PROC SYS.TREXviaDBSL 0 0 0 0 RFC RSDRP_EXECUTE_AT_QUERY_RFC
- How do we limit RAM, CPU & thread concurrency consumption by ABAP users etc. on the underlying HANA platform ??
Read more...
Environment
SAP HANA, Platform Edition 2.0
SAP HANA, Platform Edition 1.0
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
KBA , HAN-DB-PERF , SAP HANA Database Performance , HAN-DB-ENG , SAP HANA DB Engines , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.