Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to explain the performance test result in ST05

Hello everyone,

I am running a performance test for different BO report platforms using BW on different database (HANA, NLS, original disk).

By referring the document such as the following one, I ran the performance test to compare different platforms and different database.

The operation flow is:

Select the report from BW --> Clear Cache --> Before entering the parameters in the selection screen, start trace in ST05 (SQL trace) 

-->  Enter the parameters and execute  --> When report is outputted, end the trace in ST05  --> Display trace

From the report execution duration, I see that the performance of HANA > NLS > Former disk as expected, and Analysis Office > OLAP > BEx > Lumira.

But I cannot tell what the duration is about,and I cannot explain the difference among the BusinessOffice Platforms.( I thought it mainly test on database difference, but it turned out Analysis Office is also absolutely faster than BEx and Lumira). Therefore, the test result is not so persuasive as a result.

I have two questions about it:

1. What does the SQL trace in st05 evaluate? Only database or front-end also matters?

2. How to explain the difference between Analysis Office, OLAP, Webi, BEx, Lumira?

Thank you in advance.

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question