Avg. DB Request Time in Update Task

[Former Member]

Hi

In Service level report, Avg. DB Request Time in Update Task shows more than 100000 ms and it is very high. I just want to know if we want to reduce then where shd i look ? We have sufficient Update ( v1, V2 ) process in system. We dont see any queue in SM13 tcode.

I checked ST03 -> work load analysis -> database --> update V1/V2.

Can you tell me how do i reduce the db time for update ?

regards,

Rajesh Kokane

[shyam_dontamsetty]

Hi Rajesh,

I understand that your average DB time is exhibiting more than ususal.

As per standards you can check as thumb rule like avg.DBtime should not be more that 40 % of the avg.Response time.

If any excess values shows in ST03N ,then you have to find out why DBtime for executing the request is taking time.

As you mentioned, for your case avg.DBtime for update task shows high value for this case you need to corner the problem so that you can look at what causes the DBtime high.

I have suggestion for how to look at the problem in DB perspective,

1.Check all the transactions data in ST03N and list down the tcodes which crosses the 40% of the avg.DB time of the avg.response time of the respective transactions.

2.Collect all the users for the most worst transations and see what is the task that is performing on the transaction

3.If possible make an appointment with the user and activate the trace in ST05 to look at the DBtime details and see if any strange happening at DB.Make a note on the Tables involved in your SQL trace and their details

Best Regards,

Shyam Dontamsetty