cancel
Showing results for 
Search instead for 
Did you mean: 

I have these intermited slow downs on a new machine running 5R4m5

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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?

Former Member
0 Kudos

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?

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

you need to identify workload using tcode ST03.

About RSDB4UPD

check

how much memory available on your server? check using WRKSHRPOOL

regards,

kaushal

JanStallkamp
Employee
Employee
0 Kudos

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