performance tuning

[former_member211992]

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

[Former Member]

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.

[Former Member]

Hi Karthik,

Check SQL trace using tcode ST05.

Regards,

Rajesh

[former_member211992]

thanks for all ur replies,

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

[Former Member]

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

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

[Former Member]

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

[former_member536879]

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