Earlier this week, I was presenting at Great Indian Developer Summit in Bangalore. Lots of people were interested in the subject of In-Memory OLTP database. Everybody wanted to know how to do, use the new features of In-Memory OLTP feature. Microsoft has recently released two white paper which discusses about In-Memory Database.
Here is the description of the two of the whitepaper which discusses In-Memory OLTP. If you are interested in learning about In-Memory OLTP this whitepaper are great starting point.
In-Memory OLTP – Common Workload Patterns and Migration Considerations
In-Memory OLTP is a high performance, memory-optimized engine integrated into SQL Server 2014 and designed for modern hardware trends. In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures. For performance critical workloads, users can also migrate Transact-SQL code to natively compiled stored procedures. This can provide additional performance gains. This paper aims to help readers understand some of the common architectural patterns where In-Memory OLTP has provided significant benefits. The paper also discusses considerations for migrating applications to In-Memory OLTP.
SQL Server In-Memory OLTP Internals Overview
In-Memory OLTP (project “Hekaton”) is a new database engine component, fully integrated into SQL Server. It is optimized for OLTP workloads accessing memory resident data. In-Memory OLTP allows OLTP workloads to achieve significant improvements in performance, and reduction in processing time. Tables can be declared as ‘memory optimized’ to enable In-Memory OLTP’s capabilities. Memory-optimized tables are fully transactional and can be accessed using Transact-SQL. Transact-SQL stored procedures can be compiled to machine code for further performance improvements on memory-optimized tables. The engine is designed for high concurrency and blocking is minimal.
Once you go over above two white paper, here is the next learning step. Go to my friend and SQL Expert Balmukund’s blog and continue reading about In-Memory OLTP.
Reference: Pinal Dave (https://blog.sqlauthority.com)