August 2, 2005 at 5:28 am
I have 2 instances of SQL 2000 Standard running on a box with 3GB memory installed and I'm not convinced the memory is allocated correctly. Both instances are set to dynamically allocate memory and the properties tab shows the max available as 3GB (although I believe for Standard Edition the max available is 2GB)
Looking at performance monitor counters I see that instance 1 has a Total/Target Memory allocation of approx. 1.7GB whereas Instance 2 only has a Total/Target of 270MB.
Is there a way to for example, allocate 1.3GB of memory to each instance and leave about 1/2GB for the OS? Would choosing to use a fixed memory size achieve this?
thanks
August 3, 2005 at 8:55 am
Yes, you can use fixed size configuration for both instance.
Another way is still using dynamic memory configuration, but set the max memory to 1.3GB for each instance.
August 3, 2005 at 1:31 pm
It seems your one instance is at max memory (1.7 Gb is about the max). Maybe you might want top consider adding more RAM (1-2) Gb, using the /3Gb boot.ini switch and then within SQL turn on AWE for the larger instance and then set min/max memory to the same value (2048 Mb) for the larger instance and set min/max memory for the smaller instance at 1024 Mb without AWE enablement... well I'm rambling on now ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply