ETL data load - performance check

In this post I will describe a way how to analyse the performance of an SAP BW transformation. In this case, it is the transformation from Data Acquisition Layer into Data Warehouse Layer.

While running the transformation, start in another SAP GUI session SE30 - ABAP Objects Runtime Analysis:

I should look like the screen below:

Suppy a Short description and click Switch On/Off:




After the selection, an overview of all running processes is shown. In the example below, you notice for the (hidden) USERID a Dialog session and a background session.

Now select the line of the background session and select the activate icon. After that, click refresh.
Keep on refreshing until the indicator is active, green. (performance scanning is on)

When the background process is completed, scanning stops. Also, scanning can be stop manually by clicking the de-activation icon and return to the previous screen.

The main screen can be used to view the statistics. Verify that the correct logfile is selected. If you want to view previous files (to compare for example change in performance), select Other File. This brings up a list of all previous logfiles. If the required logfile is selected, click

A high level overview is shown, indication the time distribution between ABAP and Database access time (and system time). To get a higher level of detail, select the Hit List icon.

A details list of task is now displayed. Examples are Function Modules calls, database fetch time, etc.

To see the most time consuming tasks, highlight the Net % column and order the overview

Now you can see the tasks that took most of the transformation time. To improve performance, it is a good idea to check the most "expensive" tasks and see if these can be made more efficient.