SAP Knowledge Base Article - Preview

2455142 - HowTo: Bex query performance/memory analysis

Symptom

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 
  • ...

In addition, you may also check SAP Community Wiki: Query Performance and Memory that is dealing with this topic area in more detail.


Read more...

Environment

  • SAP Business Warehouse 7.x and higher
  • BW/4HANA

Product

SAP BW/4HANA all versions ; 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

Keywords

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 , bw report performance , bw query performance , analysis for office , afo , bex analyzer performance , BW-BEX-OT , OLAP Technology , BW4-AE , Analytic Engine , BW-BEX-OT-OLAP , Analyzing Data , BW4-AE-CORE , Core Services , How To

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.