bookmark_borderSetting Max memory usage in SQL Server

When running SharePoint locally it is a good idea to control the memory usage of SQL. To do this use the SQL query below.

[code lang=”sql”]
sp_configure ‘max server memory’, 1024

A good article that goes through some of the areas you need to look at in relationship to memory is located at:


I’m a principal engineer working at Microsoft. I have run and supported services for over twenty years and worked in multiple countries. I love working with passionate people and new technology.