W17 SQL Server 2014 In-memory OLTP - Deep Dive

08/20/2014

3:15pm - 4:30pm

Level: Intermediate to Advanced

Scott Klein

Data Platform Technical Evangelist

Microsoft

In this demo-filled session we will discuss Hekaton from a DBA perspective.

SQL Server's new In-Memory OLTP technology (codenamed 'Hekaton') promises to be one of the most exciting new features to be released when SQL Server 2014 ships. As a DBA you will have a number of questions surrounds its internals, how it should be administered and how it will impact you high-availability design. In this demo-filled session we will discuss Hekaton from a DBA perspective. We will look at Hekaton's architecture and internals, capacity planning considerations, administration considerations and how it impacts your high-availability design. He will also present some use cases and examples of where Hekaton can be used.

You will learn:
  • The architecture of memory optimization
  • How in-memory is integrated into SQL Server
  • The inside-look on how to use in-memory OLTP
  • How to work with the new lock-free transaction semantics
  • Manageability and supportability of in-memory OLTP