2025 Jan 18 3:18 AM - edited 2025 Jan 18 6:51 AM
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.
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
62 | |
10 | |
8 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.