We're in the process of building a new server with 128GB of RAM. We would like to utilise as much of this as possible and my understanding is that 2008, 2008R2 and 2012 (all STANDARD) are all limited to 64GB of memory.
This makes me think it is a no-brainer at this point to argue the case for SQL Server 2014 Standard, which Brent has confirmed finally upped the limit to 128GB (https://ozar.me/2014/03/good-news-sql-server-standard-editions-limits/)
However, I find this page from Microsoft (surprise, surprise) very confusing:
http://msdn.microsoft.com/en-us/library/ff642522.aspx
I expect there is some nuance in the terminology, but it seems to state two conflicting facts.
- SQL Server 2014 Standard and Enterprise supports a maximum of 64 gigabytes of system memory.
and - SQL Server Standard edition supports 128 gigabytes of system memory and SQL Server Enterprise supports a maximum of the Operating system maximum.
Which is it?!
Best Answer
have a look at this: http://msdn.microsoft.com/en-US/en-en/library/cc645993.aspx
Look at "Cross-Box Scale Limits" there you find the right Information (for 2014).
I think standard Edition supports 128GB RAM per Instance. The 64GB Ram Limit is only for Analysis Services and Reporting Services
Hope this helps.