Session Abstracts

Here are the content details for this event's available sessions.
     All Sessions   |   Room 1

  • Creating a Memory-Optimized Table
    Kalen will show you just how easy it is to create a memory-optimized table, and what you need to do to allow a database to contain these special tables.

    Session Length: 33 minutes, 23 seconds
  • Rows and Indexes
    Tables and indexes are stored completed different for memory-optimized tables than they are for disk-based tables. In this session, Kalen will show you the physical storage mechanisms used to keep track of your data. In addition, she will describe the two new kinds of indexes used to organize your data: HASH indexes and RANGE indexes.

    Session Length: 39 minutes, 55 seconds
  • Data Operations
    Operations on memory-optimized tables are completely lock-free and latch-free. Kalen will show you how this is possible by describing what happens during data modification of rows in a memory-optimized table as SQL Server creates multiple versions of the rows that are updated. She will show you how your SELECT operations know which versions are relevant and what constructs in your SELECT statements are allowed. Finally, she will tell you how SQL Server manages memory as versions become obsolete and are no longer needed.

    Session Length: 31 minutes, 21 seconds
  • Transaction Processing and Concurrency Control
    In this session, Kalen will demonstrate how logging is much more efficient for operations on memory-optimized tables. In addition, she’ll describe the concurrency management for In-Memory OLTP and tell you which isolation levels are supported.

    Session Length: 32 minutes, 31 seconds
  • Checkpoint and Recovery
    As memory-optimized tables are completely memory-resident, users often wonder how data durability is possible. What happens when SQL Server is shut down? In this session, Kalen will show you how the checkpoint process writes enough information to disk to allow for data recovery, and how the recovery process allows re-creation of both your tables and indexes. In addition, this session will include information on managing the data files on disk, and some details on backing up your databases with memory-optimized tables.

    Session Length: 49 minutes, 38 seconds
  • Native Compilation
    In memory storage with no physical reads, no locks and no latches can give big performance improvements, but to go all the way, you can also use natively compiled stored procedures to run your application code accessing memory-optimized tables. This session includes information on what’s required to create a natively compiled procedure, and a performance comparison performing the same operations using regular interpreted code.

    Session Length: 20 minutes, 33 seconds
Panel Bottom