lock pages in memory
To enable the lock pages in memory option
- On the Start menu, click Run. In the Open box, type gpedit.msc.
The Group Policy dialog box opens.
- On the Group Policy console, expand Computer Configuration, and then expand Windows Settings.
- Expand Security Settings, and then expand Local Policies.
- Select the User Rights Assignment folder.
The policies will be displayed in the details pane.
- In the pane, double-click Lock pages in memory.
- In the Local Security Policy Setting dialog box, click Add.
- In the Select Users or Groups dialog box, add an account with privileges to run sqlservr.exe.
- Restart SQL Server for this to take effect
No comments:
Post a Comment