Level: Intermediate to Advanced
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