We are testing out a new install of SQL Server 2012 on a virtual server and the memory allocated to SQL Server seems to be capped around 16 GB even though much more is available. What could cause this?
I've tried bumping up the SQL minimum server memory setting, but the change had no effect. I've listed some of the server details below.
SQL Server 2012 Enterprise Windows Server 2008 R2 Enterprise x64 29.93 GHz (8 processors) 77 GB RAM Min Server Memory: 48 GB Max Server Memory: 56 GB Database size: 44 GB
Working Set: ~17 GB Page life expectency: ~7,500 Target Server Memory: ~73 GB Total Server Memory: ~15.7 GB