SQW05 SQL Server 2014 In-memory OLTP Deep Dive


11:00am - 12:15pm

Level: Intermediate to Advanced

Grant Fritchey

Product Evangelist

Red Gate Software

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, Scott Klein 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. Scott will also present some use cases and examples of where Hekaton can be used.

You will learn:
  • How the in-memory technology is integrated into SQL Server
  • Memory provisioning and high availability
  • Manageability and supportability