I'm looking for some current advice on memory configuration for the following environment:
SQL 2008 R2, running on Windows Server 2008 R2 Enterprise x64. This is a VM with 20 GB RAM, managed by a VMware hypervisor (memory ballooning is running on my whole environment).
SQL server consistently uses 95% of available memory, despite several of my memory increases to the VM. I understand this is normal. I understand that I should NOT use "Lock pages in memory" in a virtual environment where memory ballooning is enabled.
What I haven't found online is a definite answer on whether I should set "max server memory" for this SQL config. If so, how much?