Training
Module
Configure SQL Server resources for optimal performance - Training
Configure SQL Server resources for optimal performance
This 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 Windows policy determines which accounts can use a process to keep data in physical memory, preventing the system from paging the data to virtual memory on disk.
Note
Locking pages in memory might boost performance when paging memory to disk is expected. For more information, see Lock pages in memory (LPIM).
Use the Windows Group Policy tool (gpedit.msc
) to enable this policy for the account used by SQL Server. You must be a system administrator to change this policy.
gpedit.msc
. The Group Policy dialog box opens.service_account
from sys.dm_server_services
. For more information, see sys.dm_server_services.Training
Module
Configure SQL Server resources for optimal performance - Training
Configure SQL Server resources for optimal performance