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.
Server Properties (Memory Page) - SQL Server
Get acquainted with server memory options in SQL Server. Learn about minimum and maximum server memory, index creation memory, and other settings.
Buffer Pool Extension - SQL Server
Learn about buffer pool extension and its benefits, which include improved I/O throughput. View best practices to follow when turning on this feature.