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

In addition, you may also check Support Content Page Query Performance and Memory that is discussing this topic area in more detail.

• SAP Netweaver - All Versions
• BW/4HANA - All Versions

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 , BW-BEX-OT-OLAP , Analyzing Data , BW4-AE-CORE , Core Services , BW4-AE , Analytic Engine , How To