database issue in TM

[former_member193027]

Hi,

Can someone throw light how we access or find out if there is any  database issue or where fine tuning is required for improving ABAP performance using tcode sdf/mon.

Currently when I enter into transaction and select SQL trace etc we only get info about the job and program is running status but don't have any idea about the performance of the jobs etc

[Former Member]

Hi,

     you can find many threads like this on performance check .

Regards,

Jaydeep

[former_member193027]

actually do you have step by step document as what I need to do to execute se30 for abap trace since when I enter into the Tcode  its gives me message that you are not allowed to view other traces.

[Former Member]

Hi,

Go to se30 .

there you provide your program name & in swich on/off button you can check your session is active for trace.

now you execute your program.

as soon as you will come back you will find this screen.

here you can find your all trace and you can check your DB table trace in DB Table Tab.

Regards,

Jaydeep

[bharath_k6]

Dear Dipak,

Hope you will get the answer from the below link.

http://www.sap-perf.ca/why-is-sap-background-job-running-long/

Thanks,

Bharath.K