cancel
Showing results for 
Search instead for 
Did you mean: 

How to analyse BEx Query performance using "RSRT" on SAP BW/4 HANA ?

WANGWU
Discoverer
167

Hi experts,

In SAP BW/4 HANA , the RSRT content of "Execute + Debug" changed.

So how to know the how much time or rate expend on database when running a Query.

For example, running a query is total 100 seconds, I want to know how many seconds spend on database(HANA), etc.

It is SAP BW/4 HANA system , not NW BW.

Thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

FrankRiesner
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,
the core functions in RSRT remain same in BW/4HANA, there are some enhancements, but that should be all.
Press "Execute and Debug", select "collect Statistics" + "Co not use Cache" and run the query.
When you see the query result, use the green arrow to go back.
Finally you should see the runtimes. The event IDs starting 9* are the DB times, the rest is mainly OLAP processing time.
Regards - Frank