Hello-Over the past few months we've been experiencing some performance issues, so we've been reviewing all Progress, network, OS etc....settings trying to determine where the problem might be. We're on Progress 10.2B07, AIX 64 bit. We noticed that the -B (blocksindatabasebuffers) param was set to 68000. Our db is 423 GB. Blocksize is 8192. We have 66 GB of memory on the AIX server. Our understanding of the -B parameter is that it should ideally be set to 10% of the database size. We set it to 3 million thinking this would allocate 22 GB (or so) to the Progress DB and leave 44 GB for OS, client processes, etc...
And now we're swapping. We have about 50GB of paging space and 32% is being used right now.
What we don't understand is when we do the svmon command (svmon -P -O unit=GB), it shows that there are 25 GB of memory (23.8 virtual) allocated to each of the servers in our 4GL server group.
Is this expected behavior? We were expecting 22 GB to be used for the entire Progress database buffer, not each server. (I understand that each isn't actually using that much memory for each server, as we would have crashed by now if that is the case. But we are using all 66 GB of memory plus a third of our paging space.)
Additionally, svmon shows several sqlsrv2 processes with 25 GB allocated to each of those as well. The amount of memory allocated to each sqlsrv2 process seems to directly correlate with the -B setting....if I double -B, the amount of memory for each sqlsrv2 process also doubles. It seems that each sqlsrv2 process is being allocated the -B amount.
I feel like there is something wrong or something we aren't understanding about -B. Help/advice is appreciated.
Thanks.
And now we're swapping. We have about 50GB of paging space and 32% is being used right now.
What we don't understand is when we do the svmon command (svmon -P -O unit=GB), it shows that there are 25 GB of memory (23.8 virtual) allocated to each of the servers in our 4GL server group.
Is this expected behavior? We were expecting 22 GB to be used for the entire Progress database buffer, not each server. (I understand that each isn't actually using that much memory for each server, as we would have crashed by now if that is the case. But we are using all 66 GB of memory plus a third of our paging space.)
Additionally, svmon shows several sqlsrv2 processes with 25 GB allocated to each of those as well. The amount of memory allocated to each sqlsrv2 process seems to directly correlate with the -B setting....if I double -B, the amount of memory for each sqlsrv2 process also doubles. It seems that each sqlsrv2 process is being allocated the -B amount.
I feel like there is something wrong or something we aren't understanding about -B. Help/advice is appreciated.
Thanks.