Microsoft SQL Server 2014 Unleashed

The Buffer Pool Extension

The Buffer Pool Extension feature in SQL Server 2014 is a form of memory optimization, but is separate and distinct from in-memory optimization. With the Buffer Pool Extension feature, SQL Server provides the SQL Server instance the ability to use locally attached solid-state drives (SSD) as non-volatile random access memory for buffering. This is a server-level configuration setting that allows a buffer pool to be extended beyond available physical RAM in the server to accommodate larger OLTP workloads. This helps to resolve I/O bottlenecks while improving overall I/O throughput, due to lower latency and better random I/O performance of SSDs. The larger hybrid buffer pool provides improved read performance.

The Buffer ...