Skip to Content

performance tuning

Dear all

I have got the ouput when i tuning my report in se30.

abap - 3.0%

database - 96.3%

system-0.7%

How to analyse this.

Thanks

Moderator message: frequently discussed, please search for information

The ABAP Runtime Trace (SE30) - Quick and Easy

Message was edited by: Thomas Zloch

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2012 at 05:50 AM

    Hi,

    You can refer to the following link:

    http://scn.sap.com/docs/DOC-10315

    It explains the usage of SE30 transaction in detail.

    Hope it serves useful to you.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2012 at 05:50 AM

    Hi Karthik,

    Check SQL trace using tcode ST05.

    Regards,

    Rajesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2012 at 05:51 AM

    Hi,

    In ur report it is using the db resources much.So it makes other users work difficult.Try to see ur select queries.Search on the forums of 'Perfomance Tuning;There u ll get a lot of ideas.

    Thanks,

    Karthik.R

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 11, 2012 at 06:06 AM

    Hi,

    First Goto ST05 and activate the Trace.

    Then Execute the Program . After executing deactivate the Trace in ST05 and display the Trace. There you can find which select query has taken more time to fetch the records.

    Below mentioned type of coding is not recommended by SAP.

    1) Loop inside Loop.

    2) Select * from the table.

    3) Fetching the data from the table with out using a Primary key .

    4) Sort inside the Loop.

    5) Select statement inside the Loop.

    Please have a check and let me know.

    Regards,

    Sumodh.P

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.