Resource Governor Archives - Page 2 of 2 - SQL Authority with Pinal Dave

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

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.

Diagram of the Resource Governor flow using the names from the example: requests go to the classification function dbo.UDFClassifier, which routes them to ReportServerGroup, PrimaryServerGroup or the default group, and each group uses its own resource pool; the report pool is limited to 30 percent of CPU and memory

Resource Governor Workload Groups and Pools: A Simple Setup Example

June 4, 2012

Pinal Dave

SQL Tips and Tricks

Resource Governor, SQL Performance, SQL Scripts, SQL Server

Resource Governor workload groups let you limit CPU and memory for competing workloads. This introduction answers what Resource Governor is and why you need it, then shows a full T-SQL setup example.