Average response time and DB processing time

[former_member201054]

Hi,

A background job is taking a lot of time to run .

for analysis I need to find out the system average response time and DB processing time.

Please give me the steps to find out in transaction code( if you say any) and what should be ideal value for the both them.

I would appreciate all your help.

Thanks a ton

[Former Member]

Hi,

please check the below steps.

1)Check whether Its updaing the log at db level through SM50-->Double Click on the WP which is used for job--> Will show the information like Direct Read,Seq read,insert ,update,delete and etc

2)Check whether It ahs any DB deadlock via DB01

3)You can run transaction SAT or SE30 -> new SAT to monitor what is actually happening in the program. SAT allows to measure also performance for other user, so you can just start to measure currently running process on server.

4)Update STATS

5)Can also put trace in st05 and st12.

Thanks

Rishi Abrol

[Former Member]

Hi,

You can also trace the program with transaction ST12 to get the Time Distribution.

Regards.

[AtulKumarJain]

Hi Daniel,

Please check st03n , you can find out it there.

BR

Atul