In-Memory OLTP in SQL Server 2016

Play In-Memory OLTP in SQL Server 2016
Sign in to queue

Description

On this Data Driven session, learn how In-Memory OLTP delivers performance improvements up to 30X for transactional workloads in SQL Server and Azure SQL Database. See how enhancements made in SQL Server 2016 make it easier to use and adopt in your applications, and improve performance and increase scalability even further.

Embed

Download

Right click to download this episode

Download captions

The Discussion

  • User profile image
    Mitul

    Hello Jos,

    Greeting..!!!

    This is Mitul Panchal, a database Administrator at Einfochips. I've some confusion about In-memory OLTP feature. We're planning to migrate our old SQL version to SQL server 2016. I've some difficulty regarding memory, that which memory it will use for a table, suppose our machine has 32GB RAM than it will use that RAM memory to create a table or use another memory and if it's on memory so it definitely decreases the overall performance so which memory it will use to create table and how they work? Please give me some inputs on it, which may help to understand.

    Regards,
    Mitul

Add Your 2 Cents