DKY (3/9/2014)
I have an instance of SQL Server 2008 R2 installed on a VM with 4 cpus and 16 GB of RAM. It currently uses 15.5GB of memory and I can't get it to use less. I'm having problems logging into the VM because there's not enough memory for remote desktop to function properly. I've tried setting the "Maximum server memory" setting and currently have it at 4096 but it seems to do nothing. I'm still maxing out the memory. Can anyone help?
Is SQL Server 32 bit or 64 bit ? Did you have Lock Pages in Memory enabled ?
And did you restart the SQL server after you changed the Max Memory to 4 GB ? This is to release excessive memory grabbed by SQL.
--
SQLServer