I have a SQL Server 2014 Standard (x64) instance that was recently upgraded from SQL Express.
The VM that the SQL instance is on has ~16GB of RAM and SQL MAX MEMORY has been configured to use ~12GB
I want to understand while i configured:
max server memory (MB) = 12000, why the SQL instance is not consuming more than ~4154MB when i verified it with following query:
select (physical_memory_in_use_kb/1024) usage_in_MB from sys.dm_os_process_memory