I have SQL Server 2012 SP2 that has a max memory of 25.4GB but SQL Server is only using 15GB. When I check free memory with the PerfMon SQLServer:Memory Manger Free Memory (KB) counter only 40MB is free. The server itself has 32GB.
I think that the server is only using 15GB because it only needs that much for loading all the used pages. But what I do not understand is why the free memory is only 40MB.
Can someone please explain this?
There are no other services on the system and my PLE is 122000 seconds.