I have recently migrated a 100gb database for a busy website from:
MS SQL 2008 Standard Edition R2 Windows Server 2008 48gb RAM
MS SQL 2012 Web Edition Windows Server 2012 64gb RAM
I have noticed that the usage of memory seems different in 2012, with the working set memory relatively low compared to the 2008 server (see screenshots below).
Does this seem right, and should I be concerned? I want to be sure that MSSQL has access to as much memory as it needs. The usage profiles of the two servers, in terms of requests from the website they power, is the same, so the pattern or volume of queries has not changed.
SQL Server 2008
SQL Server 2012
SQL Server 2008 memory settings
SQL Server 2012 memory settings
Thanks for any tips.