In-Memory OLTP Archives - Page 6 of 7 - SQL Authority with Pinal Dave

SQL SERVER – How to take InMemory – OLTP FileGroup Offline?

November 3, 2015

Can you take an InMemory OLTP filegroup offline, and what happens to the table data? I test it step by step using the database from my earlier post.

SQL SERVER – How to Identify InMemory Objects Can be Identified in SQL Server?

October 23, 2015

Pinal Dave

SQL Tips and Tricks

In-Memory OLTP

Is InMemory OLTP eating all my memory? Here is a step by step way to identify InMemory objects and see how much memory they use in SQL Server.

Gouache painting: a small wooden pantry shelf with a second overflow shelf beside it, but a single glass jar of preserved lemons sits apart in its own sealed cabinet with a vermilion ribbon

Buffer Pool Extension and In-Memory OLTP: What Each One Caches

March 7, 2015

Pinal Dave

SQL Performance

In-Memory OLTP, SQL DMV, SQL Memory, SQL Server Architecture

Buffer Pool Extension caches clean pages of disk-based tables on an SSD. Memory-optimized tables have no pages, so it cannot hold them. This post proves it on SQL Server 2025 with two tables and read-only checks.

Gouache painting: a small wooden coat rack in a hallway with every peg full and a stack of folded coats leaning against the wall, one last coat in a basket with nowhere to hang; one vermilion scarf on the basket coat

Insufficient System Memory: Msg 701 in a Resource Pool

January 26, 2015

Pinal Dave

SQL Tips and Tricks

In-Memory OLTP, Resource Governor, SQL Error Messages, SQL Memory, SQL Scripts

Msg 701 reports insufficient system memory in a resource pool. This post reproduces it safely with a memory-optimized table on SQL Server 2025, shows the second message you get when the rows fill the pool, and lists the fixes that worked.

Gouache painting: a pantry shelf with one wooden crate fenced off by a rope barrier and filled with pears, the other shelves open and crowded; one vermilion ribbon tied on the fenced crate

Bind Resource Governor to a Memory-Optimized Database

January 24, 2015

Pinal Dave

SQL Tips and Tricks

In-Memory OLTP, Resource Governor, SQL Memory, SQL Scripts

To bind Resource Governor to a memory-optimized database, you create a pool, bind it with one stored procedure and restart the database. This post runs each step on SQL Server 2025, proves the binding with the pool memory, and restores the server.