ABAP Runtime Analysis

[rainer_fux2]

Hello,

We have very poor performance on your ERP ECC 6.0 EHP 3 system. We are using MaxDB 7.7.

We have done a abap runtime analysis (SE30) on transaction code FD03.

The result is the following:

http://img13.imageshack.us/img13/659/fd03.png

How can we solve this? And why is the system and abap execution time equal to zero?

Regards,

Vrmr

[former_member524429]

Hi,

Please perform SQL trace using ST05. Look at the action in SM50 where it is taking more time.

Check the CPU/MEMORY bottleneck issue at DB Server using ST02 and ST06.

Also refer the following useful links to get more info.

[|]

[SAP ABAP Runtime Analysis - SE30|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30864e70-77b9-2c10-449b-e0e584f73e8c?quicklink=index&overridelayout=true]

[SE30 -Measurement Overview|http://help.sap.com/saphelp_nw2004s/helpdata/en/c6/617d2ae68c11d2b2ab080009b43351/frameset.htm]

Regards,

Bhavik G. Shroff

[Former Member]

Hi,

Also do the run time analysis using SE30. Check the select statements... As we all know, there are few options for the best performance on select statements..Please check those...

Try to avoid using inner join..also ..use indexes where ever applicable..also we can create secondary indexes...like that..

.check it once again .

Thanks,

Lakshmi

[former_member229109]

Hello,

1. We recommend to use the DB analyzer to find the bottleneck in MAXDB.

Also use SAP note 1111426 to check the configuration of the database parameters.

2. Please review the SAP note for the further recommended steps/checks:

819641 FAQ: SAP MaxDB Performance

3. There is u201CTuning SAP MaxDBu201D documentation available at https://wiki.sdn.sap.com/wiki/x/jRI

as you know.

4. Please create the SAP message, if you need help to solve the MAXDB performance issues on your system.

Thank you and best regards, Natalia Khlopina

[lbreddemann]

> How can we solve this? And why is the system and abap execution time equal to zero?

Well, it looks like that most of the time is just spend in the database.

How to solve this? Find out WHY the time is spend in the database and change this!

regards,

Lars