Just had a memory issue on a 64GB of RAM machine with SQL Server 2012 SP2. 3 running db engine instances, each limited to 16GB (16384). But noticed in Task manager that sqlservr.exe was at over 30GB memory for one of them.
What is the cause ? And is there any way to see what's eating up the RAM, next time it happens ? Can anyone explain if there's any way to limit the memory used by one instance, besides the "Maximum server memory" setting ?
