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?!