Some recent changes in the documentation for SQL Server 2014 have revealed that a couple of significant changes will have a fantastic impact on Standard Edition customers.
The first one is that the supported memory limit per instance has been raised from 64 GB in SQL Server 2008 R2 and SQL Server 2012 to 128 GB in SQL Server 2014:
Brent Ozar (@BrentO) caught this and blogged about it earlier this week, and I believe his earlier post complaining about Standard Edition, as well as repeated advice from MVPs such as Glenn Berry (@GlennAlanBerry) and others (see here and here), had something to do with this.
We can pretend, of course, that 128 GB is a huge win, forgetting that not too long ago – as recent as SQL Server 2008 – there was no limit at all in Standard Edition:
But hey, any time Microsoft decides to give us *more* for the same price, we should take as an opportunity.
Buffer Pool Extension
During the beta and public CTPs, all signs pointed to this being an Enterprise Edition feature, but – and again, this is an assumption – some loud MVPs and TAP members seem to have convinced Microsoft to loosen the restrictions here, and make this feature available to Standard Edition customers.
Of course these are the very people who are much more likely than Enterprise customers to be short on memory, and to be able to throw in commodity SSDs to compensate.