Setting 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 RECONFIGURE GO [/code] A good article that goes through some of the areas you need to look at in relationship to memory is located at:

July 30, 2010 · 1 min · Jon Bullen