Lock memory pages vista

Contents Exit focus mode. Please rate your experience Yes No. Any additional feedback? Submit and view feedback for This product This page. View all page feedback. In this article. Privacy policy. Applies to: SQL Server all supported versions. 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.

Use the Windows Group Policy tool gpedit. You must be a system administrator to change this policy. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. Asked 13 years, 4 months ago. Active 5 years ago. Viewed 2k times. The problem I'm trying to solve is how do I configure it on Vista and Server.

Anyone have a clue as to what else needs to be configured? Thanks, Staffan. Improve this question. Go to start menu on the Windows server, click Run and type gpedit. The below screen will appear after you press enter. You need to expand Computer Configuration node and then expand Windows Settings. Then expand Security Settings , here you can see the Local Policies folder.

Once you click on the User Rights Assignment folder, you can see all the Windows policies on the right. Next, search for the Lock pages in memory policy on the right. You can see this setting is not enabled because there is no account added to this policy as shown in the below screenshot. Double click the Lock pages in memory policy to open its properties window. There are two tabs in this window. Once you click the button, you will get the below screen to select the SQL Server service account.

Click Apply and OK to save and close this window. Now, you can see the SQL Server service account has been added to the Windows policy for Lock pages in memory as shown below.