topic Checking Load of Program in Database in Application Development and Automation Discussions

Checking Load of Program in Database

Former Member — Tue, 07 Aug 2012 15:10:10 GMT

Good Afternoon,

I've received a request stating that a particular program was having a 20% load on the SAP system database.

Yesterday, the development team changed the program and created a index. Now they state that the program shouldn't be generating that load.

How can i check the current load of the program in the system (since yesterday) in order to state (or not) that the load isn't 20% anymore?

Thanks in advance.

Best Regards,

Pedro

Re: Checking Load of Program in Database

Former Member — Wed, 08 Aug 2012 06:58:05 GMT

Hi ,

After execution of a program , In the status bar it displays the System , client , user , Program, Response time etc in a menu.(Bottom right corner).

Else you can use the transaction ST03 - Work loadmonitor for detail analysis.

Regards,

Arun

Re: Checking Load of Program in Database

yuri_ziryukin — Wed, 08 Aug 2012 09:29:20 GMT

First I would recommend you to wait 1 week to have more reliable data.

Then do the following:

- Start ST03 transaction

- Using the small button in the top left side of the screen choose "Expert mode"

- Expand node Workload -> Total -> Week and select (doubleclick) the week you want to analyze (if you waited 1 week as I recommended, then select the previous week).

- In the left bottom side of the screen go to "Transaction Profile" -> "EarlyWatch".

- You'll get the list of reports/transactions. Find your report and look at the column "T DB Time".

- Using ALV grid functions you can calculate Totals for "T DB Time" column and compare the total value with the value of the relevant report.

Re: Checking Load of Program in Database

Former Member — Wed, 29 Aug 2012 13:43:18 GMT

Hi,

You can also check se30- ABAP runtime analysis which gives clear picture of the load on DB.