Introduction

Memory utilization for the SQL Server Database Engine is bounded by a pair of configuration settings, min server memory (MB) and max server memory (MB). Over time and under normal circumstances, SQL Server will attempt claim memory up to the limit set by max server memory (MB)

Problem

Change the minimum memory per query

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_server_min_memory.sql

Example

Based on https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver16