Thank you for the post, Tom, Good one.
I was going through the BPE page on the msdn and came across this under best practices.
Test the buffer pool extension thoroughly before implementing in a production environment. Once in production, avoid making configuration changes to the file or turning the feature off. These activities may have a negative impact on server performance because the buffer pool is significantly reduced in size when the feature is disabled. When disabled, the memory used to support the feature is not reclaimed until the instance of SQL Server is restarted. However, if the feature is re-enabled, the memory will be reused without restarting the instance
I was just casually wondering this new SQL2014 version has very cool features and very advanced... also bit scary... any rising sql 2014 heros out there who can shed some light on the actual implementation of this feature?
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.