topic performance tuning in Application Development and Automation Discussions

performance tuning

former_member211992 — Mon, 11 Jun 2012 05:35:37 GMT

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

Message was edited by: Thomas Zloch

Re: performance tuning

Former Member — Mon, 11 Jun 2012 05:50:23 GMT

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.

Re: performance tuning

Former Member — Mon, 11 Jun 2012 05:50:29 GMT

Hi Karthik,

Check SQL trace using tcode ST05.

Regards,

Rajesh

Re: performance tuning

Former Member — Mon, 11 Jun 2012 05:51:47 GMT

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

Re: performance tuning

former_member211992 — Mon, 11 Jun 2012 06:02:04 GMT

thanks for all ur replies,

how to analstse using st05 , im not aware of that.please help me with st05

Re: performance tuning

Former Member — Mon, 11 Jun 2012 06:06:00 GMT

Hi see this thread it will help u to understand SQL trace using ST05

http://scn.sap.com/thread/542593

Re: performance tuning

Former Member — Mon, 11 Jun 2012 06:06:28 GMT

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