1. Run the SQL Server Management Studio program (should be in Programs -> Microsoft SQL Server 2008 [R2]) from an ELEVATED ADMINISTRATOR session (right click on the shortcut and do ‘run as administrator’)
  2. Connect to: [SERVERNAME]\Sharepoint , using Windows Authentication
  3. Right click on the SQL server at the top of the tree view and select properties
  4. Goto the Memory section and then type in a value for “Maximum server memory (in MB)”
    It’s a good idea to first check how much memory it’s currently using via the task manager!
  5. Click OK
  6. Restart the SQL Service

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.