on 06-10-2008 10:58 PM
I should be faster than on the old machine running 5R3 but I am getting this slow down now and then and when I look at SM50 every dialog is taken. (There seems to be a lot of Sequential reads?)
Again it is intermitent and does not seem to be related to any one transaction.
One thing that is different than on this new setup we are running RSDB4UPD.
I really have not solved this problem. The complains are from our Accounts Payable entry. I did a trace and found that it looked like this this one transaction ** took a lot of time.
51,758 EKBE FETCH 2 0
15,624 EKBZ PREPARE 0 SELECT WHERE "MANDT" = ? AND "EBELN" IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY "MANDT" , "EBELN" , "EBELP" , "STUNR" , "ZAEHK" , "VGABE
*224,319 EKBZ OPEN 0 SELECT WHERE "MANDT" = '010' AND "EBELN" IN ( '4500502057' , '4500502057' , '4500502057' , '4500502057' , '4500502057' , '4500502057' , '4500502057 111 EKBZ* FETCH 0 100
8,424 EKPO PREPARE 0 SELECT WHERE "MANDT" = ? AND "EBELN" IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) WITH UR
39,184 EKPO OPEN 0 SELECT WHERE "MANDT" = '010' AND "EBELN" IN ( '4500502057' , '4500502057' , '4500502057' , '4500502057' , '4500502057' , '4500502057' , '4500502057
IT does a select from EKBZ which has no recordes in it..
Why would this take a long time to come back when there are no records in this table?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
From what you told me and the notes the DB monitor is very hard on the system if you are not using the new monitor under 5V4.
I have changed the parameter in the TEST system to the
as4/dbmon/classic = 0
as4/dbmon/enable = 1
based on note 1083218
Can I expect a big increase in performance based on this? What have you guys seen when you disabled or used these parameters?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anthony,
if the old setting was:
as4/dbmon/classic = 1 (or not set at all)
as4/dbmon/enable = 1 (or not set at all)
Yes - otherwise no ...
This recommended parameter of note 1083218 starts a DB-Monitor where you can analyze the DB-Performance - if nobody reads the data, it is just useless. But, as this creates more or less no overhead, I would leave it, as when somebody comes in with experience, he can start directly ....
Regards
Volker Gueldenpfennig, consolut international ag
http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi.
The first thing you should check and tell us is if you have just enabled the classic memory based DB monitor or if you have switched to the new plan cache based monitor. I strongly recommend switching to the plan chache based monitor. That should increase performance significantly.
Kaushal gave a link to a recent thread were you can find the relevant SAP Notes. Please have a look.
Best regards,
Jan Stallkamp
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.