February 2, 2009 at 5:55 pm
Hello,
We have clustered ,64 bit sql server 2005 enterprise edition. We have 3 instances,created for biztalk application.We have 16GB RAM. As I read in this forum, if we do not set max memory we will get many issues.What are the metrics I need to consider to set min and max memory for the 3 instances?
can I divide the memory equally by setting max memory to 4GB for each instance(3*4 =12Gb) and 4Gb will left for OS. If this equally dividing memory works, then what will be the min memory for the 3 instances?
February 2, 2009 at 9:23 pm
I think you have the right idea. I wouldn't think that the Min Memory would be as important as the max when you choose your value. Someone else could probably give you a better idea as to 1GB or what not.
Here's a link that is discussing AWE but it goes through alot of info and has some good links throughout.
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
February 2, 2009 at 9:49 pm
As I read in this forum, if we do not set max memory we will get many issues.What are the metrics I need to consider to set min and max memory for the 3 instances?
But beware, SQL server dynamically acquires memory as needed. even if you set max memory, memory usage is acquired as needed by the SQL server until it reaches the value specified and it frees memory dynamically if it is not needed until it reaches the minimum specified value in min memory setting.
What other applications you tend to run part from SQL server?
According to BOL:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply