Skip to Content
author's profile photo Former Member
Former Member

Perfomance issue

Hi,

I want to check the program using Runtime analysis.

But can u plz tell me upto what extent(i.e percentages given in runtime analysis) can an abap report can consume time. i.e. ABAP----


%

Database-----%

R/3----


%

Why am I asking , because in production server we r having over 100000 records. so the report is working well in Development server.but when u run the report in production the problem is coming. And there is no ouptut. just processing is going on even for half an hour.Even no error...

Plz help me.........

Thanks & Regards,

K P

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2005 at 04:34 PM

    if there is a lot of processing on application server, then % of ABAP will increase, Similarly if ur queries are taking a lot of time then Database is going to increase, i would suggest u to see the hit list of queries and find out which is the most expensive query and try to tune it.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2005 at 04:34 PM

    Either ABAP or the database can consume most of the resources. If the database is consuming much more, it may indicate a bad select. Although if you are reading a lot of data and not doing much processing, then the high percentage is not a problem; however, if it's ABAP, you may have some inefficient nested loops. Long ABAP run times can normally be fixed. I've never seen R/3 consume too much.

    If you're concerned about the database, a performance trace can give you a much better idea of what's going on.

    Rob

    Message was edited by: Rob Burbank

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2005 at 04:36 PM

    Just look that the Database utilization is less than 50%

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2005 at 02:30 AM

    Hi KP,

    You use Run time Analysis and SQL trace to check if your program is having any pitfalls.

    Usually DB time should be less when compared to ABAP and R/3.

    Resolve SQL trace findings... your program will be optimal..

    Regards,

    Raj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2005 at 03:30 AM

    I have found that most of the time performace issues are caused by bad ABAP code. Here are some common mistakes to look for.

    1. Make sure that you are providing enough fields in 'where clause' to select statement to make it use an index.

    2. Avoid using select single inside Loop and Endloop. Select the data before loop using FOR ALL ENTRIES cluase before loop endloop and only read the internal table in the loop.

    3. Avoid using SELECT *. Retrieve only those columns that are actually needed.

    4. Always use binary search on standard internal table. It creates huge difference when the read statement is inside LOOP and ENDLOOP.

    Always start from run time analysis. sort the hit list by net period in descending order and start looking from the first item ( item consuming maximum time).

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2005 at 04:33 PM

    KP,

    There is no hard and fast rule.

    Usually the DB will not take more than 10%. If you have checked all the ways of improving the performance, then you can always advise the users to run the report only in the background.

    What does the run time analysis of PRODUCTION and DEV say?

    Regards,

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 23, 2005 at 04:38 PM

    Using the runtime anaylsis will not solve your problem. I would suggest doing a Sql trace for the program. This will tell you exactly what is making the program run long. I am assuming that it is spending most time on the DB. Run ST05, click the "Trace On" button, back out of ST05, run your program. Now go back to ST05, and click Trace Off, then List Trace. This will give you a listing of the Sql statements that were executing, see anything with a high number or in RED. That's where your problems are.

    Regards,

    Rich Heilman

    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.