SAP Knowledge Base Article - Preview

3314842 - Restrict or Limit Resource Usage from the HANA Database

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.