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

Read more...

Environment

SAP Business Warehouse 7.x and higher

BW/4HANA

Product

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

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 , afo , analysis for office , bex analyzer 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.