Kevin Stride (3/4/2015)
Is the best config to set the min and max memory with Hyper-V and then set a slightly lower upper limit within SQL Server? IeHyper-V
Startup mem - 4096mb
min mem - 1024mb
max mem - 32768mb
SQL
Max memory - 30720mb
Well, you don't want to configure max RAM level on SQL equal or close to the Os. You need to give Windows some room as well. If you give all available RAM to SQL, it will take, trust me. And things will get ugly.
Here is a guideline (non buffer pool area or what you leave to the Os)
-2GB for Windows
-xGB for SQL server worker threads
-1GB for miscellaneous
-1 to 3GB for other apps, like backups, linked servers, etc
Remaining one, to SQL server, upper limit.