Question Re: Average response time and DB processing time in Technology Q&A

Average response time and DB processing time

former_member201054 — Wed, 15 Jan 2014 19:00:34 GMT

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

Re: Average response time and DB processing time

AtulKumarJain — Fri, 17 Jan 2014 09:47:51 GMT

Hi Daniel,

Please check st03n , you can find out it there.

Atul

Re: Average response time and DB processing time

Former Member — Fri, 17 Jan 2014 15:14:50 GMT

Hi,

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

Regards.

Re: Average response time and DB processing time

Former Member — Sat, 18 Jan 2014 09:28:00 GMT

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