I have an issue with a SQL Server 2012 SP2 std server on a windows 2012 64-bit server
Even though I have assigned SQL Server 12GB of RAM - it won't use more than ~700MB I've simulated memory load under windows and the VM uses the RAM as it should, but if I simulate load under SQL Server it never goes above ~700MB.
I'm using this to report SQL Server memory usage:
SELECT (physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB FROM sys.dm_os_process_memory;
The DB's have been moved to this server from SQL Server 2008 which never had this issue.
The app hasn't changed - apart from running really slowly now :/
Any suggestions please?