Practical SQL Server In-Memory OLTP Tables and Objects
Pluralsight
Course Summary
A practical approach to understanding the benefits and requirements of implementing in-memory OLTP tables, indexes, natively compiled stored procedures, and UDFs. This course also treats support, monitoring, and troubleshooting IMOLTP.
-
+
Course Description
In-memory OLTP objects have created some of the most drastic performance improvements of any SQL Server feature introduced to date. Further improvements from its initial "hekaton" release to the modern version of SQL Server makes this feature not only more robust, but puts this approach within reach of the every-day DBA and database developer. In this course, Practical SQL Server In-memory OLTP Tables and Objects, you will learn the foundational make-up of SQL Server in-memory objects and what you need to leverage these objects in your projects. You'll also learn to avoid pitfalls common to working with in-memory, as well as some of the myths surrounding in-memory objects, identifying where they do and do not offer a benefit. This practical approach focuses on real world usage but gives the user a moderately deep overview of internals as well. By the end of this course, you will understand what you need to implement in-memory objects and how they can benefit you.
-
+
Course Syllabus
Introduction to In-Memory Use Cases- 12m 14s
—Course Map 4m 8s
—Use Cases 2m 58s
—Solution Needs 2m 1s
—High Level Limitations 1m 48s
—Be a Scientist 1m 16sUnderstanding In-Memory Tables- 36m 28s
—Intro 2m 55s
—Traditional Table Storage 3m 14s
—Traditional Storage Limitations 2m 51s
—Memory Optimized Row Storage 4m 11s
—Memory Optimized Isolation Levels and Navigation 4m 48s
—Memory Optimized Durability 4m 36s
—Checkpoint File Pairs 2m 58s
—Checkpoint File Pair Lifecycle 6m 30s
—Memory Optimized Limitations 4m 21sReducing Latency with In-Memory Tables in New and Existing Work- 29m 29sImproving Query Performance with In-Memory Indexes- 38m 36sGaining Complete Memory Efficiency with Natively Compiled Objects- 30m 11sAnalyzing and Monitoring Your In-Memory Solution- 23m 35s