02 July,2012 by Jack Vamvas
During investigating a performance issue – I had to restart the SQL Server Instance. On the restart this message appeared in the SQL Server Logs:
Cannot use Large Page Extensions: lock memory privilege was not granted.
How to fix the problem? Grant “Lock pages in memory” privilege to the SQL Server service account
So how can you fix this problem? Simply give the “Lock pages in memory” privilege to the SQL Server service account:
1) On the Start menu, click Run. In the “Open” box, type gpedit.msc.
2) On the “Group Policy” console, expand Computer Configuration, and then expand Windows Settings. 3) Expand Security Settings, and then expand Local Policies.
4) Select the User Rights Assignment folder.
5) In the right details pane, double-click Lock pages in memory.
6)Add the relevant account to the permissions list on this policy, the account should be the start up account for the SQL Service
7) Restart the SQL Server instance