May 22, 2012 at 4:21 am
Hi everyone, I've got 3 instances on my 64Gb dataserver but I have not yet set a max memory for any of them. I believe the recommendation is to set a max memory for each instance sharing a server. Is the best way to apportion memory to look at the batches per sec counter? For this counter I have values of 320 for instance A, 20 for B and 10 for C. Would it make sense to apportion the memory (except some for the OS of course) in these ratios?
Cheers
May 22, 2012 at 6:39 am
You would certainly want consider that metric, but understanding the database design (or lack thereof) , database sizes, type of transactional activity and the nature of the applications. Batch requests alone is not sufficient as an indication of how much memory you should allocate to an instance in my opinion.
The probability of survival is inversely proportional to the angle of arrival.
May 22, 2012 at 7:31 am
To start, I would probably set the max memory to 20GB (20480MB) on all three instances. This will 4GB for the OS. You can then monitor the instances and tune them as needed. The important thing right now is to set the max memory so that one, two, or all three instances don't suddenly starve the OS of memory due to a spike in activity.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply