It seems that even in SQL Server 2012, the maximum memory usage settings is not a hard limit. I've read some SQLOS Team blogs about this, and those as well as several MSDN articles seem to state that the maximum memory usage is just that - a maximum. But that doesn't appear to be accurate. I have a QA environment and the app and SQL are on the same server (this is typical for our application). I've tried setting maximum memory usage to both 8GB and 4GB, but eventually, usually within 24 hours, SQL is utilizing about 13GB (all available) of memory.
Is there an actual way to hard limit SQL Server to not use more than x GB of memory?
Edit: is it possible that the databases themselves being in SQL Server 2008 compatibility mode is causing this?
Target Memory (Performance Counter) is 100% of the 4GB maximum memory value I gave it. Now, of course, it's currently lower because I had to restart SQL Server services to allow anything else to work properly.
select * from sys.dm_os_process_memory: