Skip to Content
0
Jun 05, 2009 at 04:22 PM

high DB time for SAP t-codes.

142 Views

Dear All,

Good day!!!

//statistics of 1 month data from st03n,

ZTEG: 3309s(total db time ), 789.6ms avg db time per dialog step in ms , Tot Response time :17 sec

MIRO : 3145s(total db time ), 114.9ms avg db time per dialog step in ms , Tot Response time :12.5 sec

MM17 : 2873s(total db time ), 723.1ms avg db time per dialog step in ms , Tot Response time :8.2Sec

MIGO : 2286s(total db time ), 46.9ms avg db time per dialog step in ms , Tot Response time :81 sec

//

Dear All the above statistics is from 1 month data from st03n,the DB time is little for some t-codes which listed above? As part of tuning We are trying to reduce the db time , For the above SAP std. t-codes can we create index on the std. tables inorder to improve performance? or how to get this db time reduced?

our Db is tuned to an extent as we have done all the dbanalyzer and earlywatch & going live check recommendations.What is possible way to reduce the db time further?

Thanks & Regards

Tom