min/max server memory configuration
Looking for some help where I can set a fixed min/max server memory value, which is still dynamic. I need to distribute a script to different machines that have different memory configurations : 256 Mb, 512 MB and 1024 Mb. Is there a way I can dynamically change the fixed values for min/max memory based on the computer's actual amount of RAM ? Thanks.
sp_configure 'max server memory', 350
sp_configure 'min server memory', 150