SQL 2012 Standard Memory Limits

I’ve found there is a lot of confusion around the memory support of SQL 2012 Standard. Traditionally we see 2012 at 64GB and 2014 at 128GB and that is correct.

However like most things in technology it depends. Yes SQL 2012 Standard has the 64GB Limit but the Limit only applies to the buffer pool. Other SQL Server caches can consume more memory. I’d still recommend going to 2016 or 2017 where possible but if you are stuck with 2012 you can set your memory limit more than 64GB and still get some good from it.

Credit for this post goes to both Brent Ozar and Microsoft.

https://www.brentozar.com/archive/2014/12/sql-server-2012-standard-edition-max-server-memory-mb/

https://support.microsoft.com/en-us/help/2663912/memory-configuration-and-sizing-considerations-in-sql-server-2012-and?sd=rss&spid=1044