I Have SQL server 2012 standard 64bit with 64GB RAM and 40 CPU cores. In the server properties, I can see that all the RAM is listed in the memory field on the general tab. Underneath the Memory tab, I have set the minimum to 50,000 MB and the maximum is still the default value.
Both RAMMap and Task Manager show MSSQL using 27GB and having 37GB available.
What's the deal? Why isn't sqlserver and reporting server using all of the RAM when I run a large report?