Ryszard Musielak
Member
Hello,
I am not very expereienced in Progress, from Oracle and SQL-Server I know if too much memory is allocated to database buffers swapping occurs and that can lead to performance degradation. My system is setup by a third party - I expect a great deal of experience from them. This is what my TOP command shows:
As you can see practically all of the 16GB of memory is allocated. Although swapping is very low (only 24M used) I would like to ask what is your opinion? Should I monitor the system at this stage and worry?
With Oracle databases I avoid swapping at all costs. With SQL-Server I have reduced the buffer allocation to allow 4GB free for the system, the rest is for the DB server. Above that Windows event viewer was showing processed crashing and clear message there was not enough physical memory.
Any recommendations?
My Progress is on a Red Hat Linux.
Thank you
Richard
I am not very expereienced in Progress, from Oracle and SQL-Server I know if too much memory is allocated to database buffers swapping occurs and that can lead to performance degradation. My system is setup by a third party - I expect a great deal of experience from them. This is what my TOP command shows:
top - 08:02:30 up 172 days, 12:55, 8 users, load average: 1.37, 1.60, 1.61
Tasks: 587 total, 2 running, 585 sleeping, 0 stopped, 0 zombie
Cpu(s): 9.1%us, 1.7%sy, 0.0%ni, 86.5%id, 2.3%wa, 0.1%hi, 0.3%si, 0.0%st
Mem: 16360448k total, 16276052k used, 84396k free, 30268k buffers
Swap: 4707036k total, 24908k used, 4682128k free, 11312424k cached
Tasks: 587 total, 2 running, 585 sleeping, 0 stopped, 0 zombie
Cpu(s): 9.1%us, 1.7%sy, 0.0%ni, 86.5%id, 2.3%wa, 0.1%hi, 0.3%si, 0.0%st
Mem: 16360448k total, 16276052k used, 84396k free, 30268k buffers
Swap: 4707036k total, 24908k used, 4682128k free, 11312424k cached
As you can see practically all of the 16GB of memory is allocated. Although swapping is very low (only 24M used) I would like to ask what is your opinion? Should I monitor the system at this stage and worry?
With Oracle databases I avoid swapping at all costs. With SQL-Server I have reduced the buffer allocation to allow 4GB free for the system, the rest is for the DB server. Above that Windows event viewer was showing processed crashing and clear message there was not enough physical memory.
Any recommendations?
My Progress is on a Red Hat Linux.
Thank you
Richard