Boost SQL Server Database Performance with In-Memory OLTP

Learn how to use the powerful In-Memory OLTP Engine in SQL Server for improving database performance

4.45 (21 reviews)
Udemy
platform
English
language
Databases
category
129
students
3 hours
content
Apr 2022
last update
$84.99
regular price

What you will learn

How to Use In-Memory OLTP for Boosting the Performance of your Data Processes

What is the In-Memory OLTP Engine in SQL Server

What are Memory-Optimized Tables

What are Natively-Compiled Stored Procedures

How to Migrate to In-Memory OLTP

Description

In this course you will learn all about SQL Server's In-Memory Database Processing Engine also known as In-Memory OLTP. To this end, you will learn how to enable In-Memory OLTP in SQL Server, what memory-optimized tables and natively-compiled stored procedures are, as well as, how to boost the performance of your data processes using this powerful SQL Server feature.

In-Memory OLTP, is SQL Server's Database In-Memory Processing Engine, seamlessly integrated into its Database Engine. With its two main components, that is memory-optimized tables and natively-compiled stored procedures, In-Memory OLTP can help you achieve significant performance improvements and speedups for many of your data processes.

In-Memory OLTP was originally shipped with SQL Server 2014 but was significantly enhanced in SQL Server 2016 and later. From SQL Server 2016 SP1 and later, In-Memory OLTP is available for use in all editions of SQL Server (besides the LocalDB edition), which is something that makes it a must, to at least try this great feature in SQL Server.

Especially now, in this data-driven era we live in, where business decisions and many other areas depend on the fast analysis of large sets of data, maintaining a low latency for your data processes is critical. SQL Server's In-Memory OLTP Engine can help with that.


WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

  • "Excellent and helpful course regarding SQL Server. Very suitable for my job."

  • "So far the course is great! The simplicity of explaining the different concepts is outstanding!"

  • "An easy to follow course with excellent content!"

  • "I was impressed by this course! It explains in plain words how to utilize In-Memory Optimization in SQL Server and the demos are really amazing."


THE BENEFITS OF THIS COURSE:

By the time you complete this course, you will know:

  • What is the In-Memory OLTP Engine in SQL Server and how it works

  • What Memory-Optimized Tables are and which are their main characteristics

  • What Natively-Compiled Stored Procedures are and how they work

  • How to Use In-Memory OLTP for Boosting the Performance of your Data Processes, by utilizing memory-optimized tables and natively-compiled stored procedures

  • How to migrate your data processes to In-Memory OLTP

    • How to find the right candidate databases, data processes and tables for migrating it to In-Memory OLTP 

    • How to analyze your tables and stored procedures prior to planning their migration to In-Memory OLTP

    • Ways to estimate if your workload's performance can benefit from In-Memory OLTP


MAJOR LEARNING OBJECTIVES:

Throughout the course, I will take you through all the necessary steps that you need to learn, in order to start utilizing SQL Server's powerful In-Memory OLTP engine.

First, via the introductory section, you will learn what In-Memory OLTP is and which are the best-suited workloads for In-Memory OLTP.

After that, we will be discussing about the requirements for enabling In-Memory OLTP in SQL Server, and we will create together, a SQL Server In-Memory OLTP-Enabled database.

Then, we will thoroughly discuss about memory-optimized tables, and you will learn how to create and use durable and non-durable memory optimized tables in SQL Server. Moreover, we will run some examples for comparing the performance of these two types of memory-optimized tables.

After that, we will be discussing about natively-compiled stored procedures in SQL Server, and among other, you will learn how to create and use this special type of SQL Server stored procedures. Moreover, we will run some interesting examples, for comparing the performance of a disk-based process vs. a process that uses memory-optimized tables vs. a process that uses memory-optimized tables combined with natively-compiled stored procedures.

Then, we will be discussing about how you can improve the performance of your database workload using In-Memory OLTP, and more specifically, we will discuss about, how you can migrate your databases to In-Memory OLTP and how you can estimate if your specific workload type, can benefit from In-Memory OLTP processing in SQL Server.

Finally, we will go through together, many examples of using In-Memory OLTP in SQL Server, where among other, we will be comparing the performance of different disk-based processes vs. processes that use memory-optimized tables vs. processes that use memory-optimized tables combined with natively-compiled stored procedures.


PREREQUISITES:

  • Basic knowledge of SQL Server and data principles


THIS COURSE CONTAINS/OFFERS:

  • 3 hours of high-quality video

  • Live demonstrations and hands-on guides

  • Useful quizzes for testing your knowledge on each section

  • Many downloadable resources (i.e. summaries and T-SQL scripts)

  • A practice test in the end of the course

  • Ability to ask the instructor questions via the Q&A section

  • Certificate on course completion

Screenshots

Boost SQL Server Database Performance with In-Memory OLTP - Screenshot_01Boost SQL Server Database Performance with In-Memory OLTP - Screenshot_02Boost SQL Server Database Performance with In-Memory OLTP - Screenshot_03Boost SQL Server Database Performance with In-Memory OLTP - Screenshot_04

Content

Introduction

Welcome to the Course! What Will You Learn?
What is In-Memory OLTP in SQL Server?
Best-Suited Workload Types for In-Memory OLTP
Limitations of In-Memory OLTP in SQL Server
How Can this Course Help You?
Section Recap
Introduction

Enabling In-Memory OLTP in SQL Server

Section Overview
Requirements for Enabling In-Memory OLTP in SQL Server
How to Create a SQL Server In-Memory OLTP-Enabled Database
In-Memory OLTP T-SQL Limitations
Section Recap
Enabling In-Memory OLTP in SQL Server

Memory-Optimized Tables

Section Overview
What are Memory-Optimized Tables in SQL Server?
Creating a Non-Durable Memory-Optimized Table
Creating a Durable Memory-Optimized Table
Let’s Compare the Performance Between Disk-Based and Memory Optimized Tables
Section Recap
Memory-Optimized Tables

Natively-Compiled Stored Procedures

Section Overview
What are Natively-Compiled Stored Procedures in SQL Server?
Creating a Natively-Compiled Stored Procedure in SQL Server
Performance of Disk-Based vs Memory Optimized Tables vs Natively Compiled SPs
Section Recap
Natively-Compiled Stored Procedures

Improving SQL Server Performance Using In-Memory OLTP

Section Overview
Migrating your Databases to In-Memory OLTP: The Right Candidates
Will your Workload Execute Faster?
Ways of Estimating if You Can Benefit from In-Memory OLTP
Section Recap
Improving SQL Server Performance Using In-Memory OLTP

Examples of Using SQL Server In-Memory OLTP

Section Overview
About our Test Environment
Scenario: Import Text File of 100K Records
Scenario: Update Single Column in Table with 100K Records
Scenario: Run Aggregation on a Table with 100K Records
Section Recap
Examples of Using SQL Server In-Memory OLTP

Putting it All Together

What Have you Learned in this Course?
Boost SQL Server Database Performance with In-Memory OLTP

Learning More

Bonus Lecture

Reviews

Phanindra
April 18, 2022
This was very nice course about In-Memory Database & Providing more details about the Memory Optimized Tables & Natively-Compiled Stored Procedures.
Sayedkhalidsultani
November 25, 2021
thanks for the course , further material can be added on replication on memory optimized tables and HA considerations.
Thomas
January 14, 2021
Ich fand den Kurs recht gut, die Ausführungen waren klar und verständlich. Es wäre aber nicht nötig, die immer ähnlichen Vergleichstabellen und Diagramme die auch immer das gleiche Ergebnis liefern, jedes Mal so enorm ausführlich zu beschreiben.
Shaima
August 2, 2020
The course is giving high level and quick information. Since this course is advanced level and specifically for in-memory OLTP, as DBA i was expecting in depth information of the technology it self, how tables are being created and accessed in the memory without blocking, how durable tables are in sync between memory and disks.
Giannis
June 5, 2020
I was impressed by this course! It explains in plain words how to utilize In-Memory Optimization in SQL Server and the demos are really amazing.
Doros
June 3, 2020
Another great course from Mr. Artemiou. I especially like the clear structure, and it is surely full of helpful info and tips. Thanks!!

Charts

Price

Boost SQL Server Database Performance with In-Memory OLTP - Price chart

Rating

Boost SQL Server Database Performance with In-Memory OLTP - Ratings chart

Enrollment distribution

Boost SQL Server Database Performance with In-Memory OLTP - Distribution chart
2198958
udemy ID
2/5/2019
course created date
7/24/2020
course indexed date
Bot
course submited by