on 10-20-2005 11:24 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi Mirella.
for the perfomance it's not importend, in which instance (central or appl) do you define the update process.
Regards
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
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.