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

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

October 23, 2015

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.

Gouache painting of blue blocks passing through matching shaped openings while grey blocks remain in a separate compartment.

Filter Memory-Optimized Tables in SSMS: SQL in Sixty Seconds #079

January 7, 2015

Pinal Dave

SQL Video

In-Memory OLTP, SQL in Sixty Seconds, SQL Server Management Studio, SQL System Table

You can filter memory-optimized tables in SSMS Object Explorer, or find them with one query on sys.tables. The tests here build a database with both kinds of tables, show how durability and memory use appear in the catalog, and list the gotchas.