SQL Server 2014 aimed to improve OLTP performance by adding In-Memory tables and native compilation of the stored procedures that use them. In-Memory tables bring incredible speed for the right workload so long as a series of limitations can be observed. This presentation describes what In-Memory tables are and how they’re implemented in a way that retains the ACID database properties that we rely on in disk based tables. We’ll discuss:
- How In-Memory tables are persisted
- How data is exchanged with disk based tableSQL Server In-Memory Tables(Hekaton) Andy Novick April 2015s
- Limitations of natively compiled stored procedures that achieved maximum performance
- How far do In-Memory tables allow us to go.
- Interactions with the delayed durability feature of SQL 2014
- In-Memory @table variables
We’ll also take a look at some of the things that in-memory tables are not intended for and explore how they can be pushed.
Andy Novick is a Boston area consultant, author, and MVP who specializes in developing high performance SQL Server databases and T-SQL code. He’s been a speaker at Boston area user groups and at SQL PASS for many years. His web site, NovickSoftware.com, features numerous articles for SQL Server developers.