SAP Knowledge Base Article - Preview

2455142 - HowTo: Bex query performance/memory analysis


The following decision tree will assist you with analysing and troubleshooting performance and memory issues in Bex queries.

Guided Answers: Bex query performance/memory analysis

Issues that can be identified/solved/explained/understood with this Guided Answer/ Decision tree are:

  • long runtime
  • memory dumps
  • RSRT Bex statistics
  • increasing performance
  • runtime issues in analytic engine vs. database
  • correlation of runtime/memory issues to the usage of certain BEx query features
  • impact of data modeling on BEx query performance/memory 
  • ...



SAP Business Warehouse 7.x and higher



SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0


performance, memory, time-out, time_out, runtime, BICS, MDX, SQL, TIME_OUT, slow, long, DBTRANS, DBSEL, TSV_NEW_PAGE_ALLOC_FAILED, STORAGE_PARAMETERS_WRONG_SET, SYSTEM_NO_ROLL, BEx query, RSRT statistics, event 9000, event 3100, event 3200, HCPR, hierarchy node resolve , KBA , ao , analysis for office , afo , bex analyzer performance , bw report performance , bw query performance , BW-BEX-OT , OLAP Technology , BW4-AE , Analytic Engine , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.