Summary
In-Memory OLTP and memory-optimized tables are exciting new features in SQL Server 2014. It is poised to be a game changer for OTLP based applications. However, it’s important to understand it’s not the solution for every OLTP application experiencing performance issues. The information in this chapter should help you understand what in-memory optimization is and how to implement it successfully to realize the significant performance gains it can provide.
This chapter also introduced the Buffer Pool Extension, a feature that you can implement to provide additional buffer pool space from attached SSD drives beyond the available physical RAM in SQL Server. This feature can help to resolve I/O bottlenecks while improving overall I/O throughput, ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
