- 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’)
- Connect to: [SERVERNAME]\Sharepoint , using Windows Authentication
- Right click on the SQL server at the top of the tree view and select properties
- 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!
- Click OK
- Restart the SQL Service