- Overview of In-Memory OLTP
- In-Memory Optimization Requirements
- Limitations of In-Memory OLTP
- Using In-Memory OLTP
- Using Memory-Optimized Tables
- Logging, Checkpoint, and Recovery for In-Memory OLTP
- Managing Memory for In-Memory OLTP
- Backup and Recovery of Memory-Optimized Databases
- Migrating to In-Memory OLTP
- Dynamic Management Views for In-Memory OLTP
- The Buffer Pool Extension
- Summary
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, due to lower latency and better random I/O performance of SSDs over standard disk drives.
The next chapter, ”Understanding Query Optimization,” takes a deeper dive into understanding SQL Server performance by providing an in-depth discussion on how SQL Server evaluates your queries to develop an optimal query plan for processing your queries.