Dynamic Memory Qestion - Looking for Knowledge

[JayKusch]

Needing to get a few comments on what others have set or seen with the configuration of memory on a SQL Server(SS).

Say we have a server w/ 2GB of RAM. The Systems Engineers(SE) have seen where SS has allocated, and does not want to release, the full 2GBs when the system has a heavy load. Thus it starves the other services on the system.

Issue seems to be, SS does not want to reallocate, release, the memory it aquired during its heavy load once that load has subsided.

Thus we have set the memory allocation to a Min of 1GB and a max of 1.5GB.

Questions is ... which is the preferred option, besides the default setting of letting SS Dynamically allocate ALL of the RAM ...

A. Let SS Dynamically configure the RAM based on a predefined Min 1GB/Max 1.5GB value ... OR

B. Just set a Fixed allocation of 1.5GB

Thanks

J. Kusch

 

[ClaireHCM]

If you have no other application on the same box, then let SS takes control, If you do, better give some range for SS to prevent other application being hungry for memory.

Fixed memory may not be a good idea if your SS is an intensive worker. It's going to cause performance issue in the long run. Either you remove co-exists application or add some more memory for your box.