Home > Articles > Data > SQL Server

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

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.

  • + Share This
  • 🔖 Save To Your Account