cancel
Showing results for 
Search instead for 
Did you mean: 

update process

Former Member
0 Kudos

Hello Gurus,

I have a fundamental basis question about distribution of update processes.

What is the effect or difference between configuring Update processes in Apps server vs in Central instance (with database)?

Is it better for performance if update process is all located in central instance than in apps server or does placing some in each apps server help reduce update load on the database or it does not?

Hope someone can advice me a little as my database is running poorly and users will be screaming at me.

Regards,

Mirella

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello,

If your database is running poorly relocating update processes doesn't help.

You should try to find the reason why your db is running poorly. First check where is the bootleneck -> CPU, memory, disks, ... than try to isolate the problem...

This is a complex task.

Marcin

Former Member
0 Kudos

Dear Marcin,

I found the bottleneck is high disk reads although slightly lower disk write! I cannot understand this figures.

I'm using SQL server 7. The Buffercache hit ratio is 99% and basically all SAP buffers (ST02) are 99%.

But I see quite a lot of SAP buffer swaps for areas like program buffer, table buffers. Would this be reasons for high disk reads? Seems like not a SQL database buffer bottleneck that is causing the high disk reads since the hit ratio is 99%.

So what could be causing this high read vs comparatively slightly lower disk write time?

Hope experts here can share with me some advice.

Will greatly appreciately it.

Thanks.

Regards,

Mirella

Former Member
0 Kudos

Hi Mirella.

for the perfomance it's not importend, in which instance (central or appl) do you define the update process.

Regards

Markus