Skip to Content
avatar image
Former Member

update process

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 20, 2005 at 11:33 AM

    Hi Mirella.

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

    Regards

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2005 at 10:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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