Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
This option is still present in the sp_configure stored procedure, but its functionality is unavailable in Microsoft SQL Server. (The setting has no effect.)
Important
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Configure SQL Server resources for optimal performance - Training
Configure SQL Server resources for optimal performance
Documentation
Server configuration: min memory per query - SQL Server
Learn how to use the min memory per query option to specify the minimum number of kilobytes that SQL Server allocates for a query.
sp_configure (Transact-SQL) - SQL Server
sp_configure displays or changes global configuration settings for the current server.
sys.configurations (Transact-SQL) - SQL Server
sys.configurations (Transact-SQL)