Frequently Asked Questions About SQL Server In-Memory OLTP

Hi friends! In this article, we will be answering different frequently asked questions about SQL Server In-Memory OLTP. We will begin with the basics and then move to more advanced-level questions. What is SQL Server In-Memory OLTP? SQL Server In-Memory OLTP, is a powerful engine, seamlessly integrated into the SQL Server Engine (version 2014 and … Read more…

Tip of the Week No.13- SQL Server Support for In-Memory OLTP

Check our Tip of the Week, which this week discusses about the availability of the In-Memory OLTP feature in different SQL Server versions and editions. Tip of the Week #13 In-Memory OLTP was initially released with SQL Server 2014 and was supported in the Enterprise, Developer and Evaluation editions. Since SQL Server 2016 SP1, In-Memory … Read more…

Boost SQL Server Database Performance with In-Memory OLTP (Course Preview)

In this article, we are presenting our new course titled “Boost SQL Server Database Performance with In-Memory OLTP” and explain how can the course help you, significantly improve the performance of your SQL Server-based data processes.   What is In-Memory OLTP in SQL Server? In-Memory OLTP, is SQL Server’s powerful In-Memory Optimization Engine, which is … Read more…

Getting Started with SQL Server In-Memory OLTP – Part 2

In my previous article of this blog series, I introduced SQL Server In-Memory OLTP and explained how it is possible to create an In-Memory OLTP – enabled database. Also, I showed via simple examples, how easy is to create memory-optimized tables (durable and non-durable). Today we are going to talk about naively-compiled stored procedures as well … Read more…

Getting Started with SQL Server In-Memory OLTP – Part 1

SQL Server In-Memory OLTP (MS Docs article) is a powerful engine integrated into the SQL Server Engine (version 2014 and later), optimized for Online Transaction Processing (OLTP). This article helps you getting started with SQL Server In-Memory OLTP and it is the first part in a series of articles focusing on SQL Server In-Memory OLTP.   … Read more…

In-Memory OLTP Simulator: The Experiment

A few days ago I published a 38-page technical paper titled “In-Memory OLTP Simulator: The Experiment“. In-Memory OLTP Simulator is a software tool that we developed, which allows the user to easily simulate virtually any workload against the powerful In-Memory OLTP Engine of Microsoft SQL Server.   What Does the Paper Discuss? This paper presents … Read more…

In-Memory OLTP Simulator Frequently Asked Questions (FAQ)

In-Memory OLTP Simulator Frequently Asked Questions (FAQ): What is In-Memory OLTP Simulator? In-Memory OLTP Simulator is third-party tool that allows the user to easily create and run scenarios with different workloads against the In-Memory OLTP Engine of SQL Server®. What is a Simulation Scenario? A simulation scenario is a set of table and stored procedure … Read more…

In-Memory Optimization in SQL Server: Will my Workload Execute Faster?

In-Memory OLTP in SQL Server 2014 or later is a powerful engine integrated into the SQL Server Engine, optimized for Online Transaction Processing (OLTP). In-Memory Optimization in SQL Server, has certain characteristics and can help increasing performance in a great number of scenarios.   A Short Description of the SQL Server In-Memory OLTP Technology If I … Read more…

Introducing In-Memory OLTP Simulator

One of the key features originally shipped with SQL Server 2014 was the long-awaited In-Memory OLTP, codenamed as project “Hekaton”. In-Memory OLTP introduced new data structures for optimizing the performance of OLTP workloads. These data structures are called “memory-optimized” tables and along with natively compiled stored procedures, they can offer a huge performance boost when … Read more…

In-Memory Optimization in SQL Server: A Simple Experiment

In this article, we will be discussing about In-Memory Optimization in SQL Server, and we will see a simple example, of optimizing a workload using In-Memory Optimization and thus improve performance.   Introduction to SQL Server In-Memory Optimization In one of my previous articles I briefly introduced In-Memory Optimization in SQL Server. In this article … Read more…

Introducing In-Memory Optimization in SQL Server

In-Memory OLTP (codenamed “Hekaton”) is the most significant feature originally shipped with SQL Server 2014. It is Microsoft’s new technology which is fully integrated into SQL Server’s Database Engine. In-Memory OLTP introduces new data structures for optimizing the performance of OLTP workloads. These data structures are called “memory-optimized” tables and along with natively compiled stored … Read more…

The In-Memory OLTP Engine in SQL Server 2014: An Overview

A few days ago, on March 21st, I participated as an invited speaker at Microsoft Conference 2014 that took place in Nicosia, Cyprus. My session was on SQL Server 2014 and specifically about what’s new in this release of SQL Server. My session’s agenda was on the following areas of new features on SQL Server: … Read more…