on 10-20-2010 6:23 AM
Dear all,
My Production server is running very slow.
I am sending ST03N log:
Dispatcher wait time(Wait Time)- 0.4 ms
Load+Gen Time- 4.5 ms
Roll-in Time- 0.6 ms
Roll Wait Time- 94.7 ms
Gui Time- 96.0 ms
Processing Time- 90.3 ms
CPU Time- 51.9 ms
Database Time- 486.8 ms
Response Time- 677.4 ms
Wait Time- 0.4 ms
Regards,
PC Patel
This is very vast topic.
What is your OS and DB.
Is your stats are upto date?
also check in SM50 what action you see when user perform any transaction.
check for your disk operations (is there any IO wait)
also when you have identified system is slow? have you applied any patches or kernel upgrade?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Generally MB51 uses table MSEG, this is table which contain heavy data.
Can you check how much is a data present in table MSEG table. Is there any customize index created for this table. If no, then i will suggest to create index for table MSEG with field MANDT, LFBNR and LFPOS.
As you aware MB51 is nothing but to check the list of material document which basically make select on above fields.
Thanks
Anil
Hi,
Create new index with field MANDT, LFBNR & LFPOS.
Every field in index has different logic of reading the data.
Before creating the index, seat with the user who is facing thr problem and check what time it take to get the output of MB51.
Then create the index as above and then again run MB51 and now check what time it takes for getting the output.
Thanks
Anil
PC,
Check if the statistics are up to date in tcode DB20 for tables flashing in SM50 and if not then create the statistics for them.
Check AVg(ms) in ST04->Details analysys->File system requests->AVg(ms) ,It should be less than 10ms for datafiles,if not then there's I/o problem and you need to relocate the datafiles to some other disk.
Also run sql trace in ST05 and check for the expensive sql statements.
Below link might help you in sql optimization.
https://websmp202.sap-ag.de/~sapidb/011000358700001413351999E#row_162
Hi,
Have you taken a look for SAP Notes on the performance of MB51? I've come across a similar situation in the past with other transactions and I've sometimes found this is caused by inefficiencies in the transaction that can be corrected.
If not, try searching for "MB51 Performance" in the SAP Note search. You may find some that give advice on how to improve performance of the transaction. For example, https://service.sap.com/sap/support/notes/921164.
I usually try to take a look at these first of all and then carry out further analysis if there are no known issues.
Hope this helps.
Regards.
Steve.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.