April 15, 2002 at 6:36 am
I have 5 Instances of SQL Server 2000 Enterprise Edition installed. I want to set a maximum limit on the RAM usage for each Instances.
1. What steps are involved ?
2. Does this require a reboot for each Instance ?
April 15, 2002 at 6:56 am
Generally I would follow the rule of total amount available to all instances as 90% with a minimum of 64-80 Mb for the OS.
So depending on what each instance is doing split how you see fit but try to keep 80mb or beter minimum for each SQL instance.
To adjust open EM, right click the instance to change, select Properties and the Memory tab.
Now since you will have multiple instances you can use dynamically config and set the Maximum (MB) to the value you came up with.
For higher stability with so many instances and to limit contention with swapping of memory resources you may want to set a fixed memory size instead but you will need to test to see the effect.
Now just to throw in I personally would not use multiple instances since you have to load the SQL executables (SQl, Agent, others) into memory multiple times and thus loose some potential memory with this fact.
After making the change definently reboot the entire server to make sure the new settings take effect properly.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply