We're relocating our database to a 64-bit server, and try as I might I can't seem to get the maximum memory setting to have any effect on things. I know the 64-bit version is a bit different when it comes to memory management (no AWE) but does it also not let you set the maximum memory?
As you can imagine, it just eats up my ram until other applications start breaking--hence my need to limit it.
I've tried stuff like
exec sp_configure 'show advanced options', 1;
exec sp_configure 'max server memory (MB)', 100;--or whatever number you wish
and while that number does change the config_value I see when I run sp_configure, the sqlservr.exe process just keeps eating up memory.
Thanks in advance for any pointers!