SQL Server is a powerful relational database management system that offers various features to optimize performance and improve efficiency. One such feature is In-Memory OLTP, which is designed for modern hardware trends and allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures.

In-Memory OLTP provides significant benefits for performance critical workloads. It allows OLTP workloads to achieve improvements in performance and reduction in processing time. By declaring tables as ‘memory optimized’, users can take advantage of In-Memory OLTP’s capabilities. These memory-optimized tables are fully transactional and can be accessed using Transact-SQL.

Microsoft has released two whitepapers that discuss In-Memory OLTP in detail. The first whitepaper, “In-Memory OLTP – Common Workload Patterns and Migration Considerations”, aims to help readers understand common architectural patterns where In-Memory OLTP has provided significant benefits. It also discusses considerations for migrating applications to In-Memory OLTP.

The second whitepaper, “SQL Server In-Memory OLTP Internals Overview”, provides an overview of the In-Memory OLTP engine component, also known as “Hekaton”. It explains how this component is optimized for OLTP workloads accessing memory resident data. The whitepaper also highlights the ability to compile Transact-SQL stored procedures to machine code for further performance improvements on memory-optimized tables.

If you are interested in learning more about In-Memory OLTP, I highly recommend downloading and reading these whitepapers. They serve as a great starting point to understand the concepts and benefits of In-Memory OLTP in SQL Server.

Once you have gone through the whitepapers, you can continue your learning journey by visiting my friend and SQL expert Balmukund’s blog. He provides further insights and practical examples on In-Memory OLTP.

Stay tuned for more articles on SQL Server and its features!