SQL Server: Memory-Optimized Tables

Watch video PAST EVENT
SQL Server: Memory-Optimized Tables

On 29 October 2020, SSA Group hosted its first webinar for database developers. Experienced SSA Group database developers Mykhailo Berezhnyi and Vitalii Gryniuk presented the benefits and limitations of memory-optimized tables in SQL Server.

This online event brought together 100 database experts. The aim was to provide solutions for the possible issues that may happen while creating in-memory OLTP. It was a record-long webinar that continued for two hours, excluding the Q&A session. Attendees not only asked questions but also actively shared their own experiences with memory-optimised tables.

The video from the webinar is available on our YouTube channel.

Speaker
Mykhailo Berezhnyi

Mykhailo Berezhnyi

Database developer

Vitalii Gryniuk

Vitalii Gryniuk

Database developer

Agenda
  1. Introduction. History. Changes in versions
  2. Benefits of in-memory OLTP
  3. Creation of memory-optimized tables. Record structure. Checkpoint files and pairs
  4. Indexes on memory-optimized tables
  5. Transactions for in-memory OLTP. Optimistic multi-version concurrency control (MVCC)
  6. Productivity comparison examples
  7. Checkpoint for disk-based and MO-tables. Checkpoint files lifecycle
  8. Memory Optimisation Advisor. Memory size consideration
  9. Natively compiled procedures
  10. Memory-optimized tables variables
  11. Limitations of in-memory OLTP

This online event brought together 100 database experts seeking awareness of the issues that can be faced while creating in-memory OLTP and ways to solve them. It was a record-long webinar that continued for two hours, excluding the Q&A session. Attendees not only asked questions but also actively shared their own experiences with memory-optimised tables.

webinar_speakers

Video version (In Russian)

You may also like

Magento Performance Optimization
Video PAST EVENT

Magento Performance Optimization

The experienced speakers from the Ecommerce department highlighted the approaches and tools for analyzing and improving the Magento webshop's backend performance.

you're currently offline