January 20, 2011 at 1:31 pm
Hey DBA's,
I've been told to allocate 16Gig for one clustered instance and 8Gig for another. What would the settings be for Min and Max Memory?
January 20, 2011 at 1:33 pm
I failed to mention that the instances are 64bit Enterprise Edition.
The server has 64Gig installed.
January 20, 2011 at 2:44 pm
Patricia Johnson (1/20/2011)
Hey DBA's,I've been told to allocate 16Gig for one clustered instance and 8Gig for another. What would the settings be for Min and Max Memory?
I normally don't set min memory, but on a multi-instance cluster I might consider it. I would set the min memory to at least 2GB less than max memory, as there have been documented issues with setting min/max the same.
As for the max memory settings: 16GB and 8GB, respectively.
The actual values are in MB so all you need to do is take 16*1024 and 8*1024 to get the actual values to set.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 20, 2011 at 3:00 pm
Hey Jeffrey,
So what you are saying is that I should set:
16Gig instance:
min=14336
max=16384
8Gig instance:
min=6044
max=8192
January 20, 2011 at 3:25 pm
Usually Min memory is not required. Maximum memory is the main setting required to be set. Also you need to consider the number of instances running on the cluster and the failover situation. But you can implement Jeffrey's recommendation.
Thank You,
Best Regards,
SQLBuddy
January 20, 2011 at 3:28 pm
Thanks. I was also trying to confirm that I understood what he said. I guess I did. Thanks again.
🙂
January 20, 2011 at 3:38 pm
Yes you got them right. 🙂
Thank You,
Best Regards,
SQLBuddy
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply