high processing times and as well CPU times (they are around the same) in transaction mb51 on WIN/SQL based system

[Former Member]

Hello

On one system Windows/SQL based  I noticed very high processing times and as well CPU times (they are around the same) in transaction mb51

On an oracle based system i would look at databse statistics for related tables but in MSSQL I do not have idea

Please help

Jan

[former_member188883]

Hi Jan,

Transaction code MB51 uses table MKPF and MSEG table for fetching data. In case number of entries in these tables are very high this may result in slow performance for this transaction.

Could you share the number of entries in these 2 tables.

Regards,

Deepak Kori

[Former Member]

Hi Jan,

Please take the trace from tcode ST12 or ST05 for the process of Tcode MB51. look into sql analysis and abap analysis. Also you can check the database alert or log issue form tcode DBACOCKPIT.

Regards

Pravin