Setting Max memory usage in SQL Server

Posted by Jon Bullen on 2010-07-30
Estimated Reading Time 1 Minutes
Words 68 In Total

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: http://www.eraofdata.com/blog/2008/10/sql-server-memory-configuration/


If you like this blog or find it useful for you, you are welcome to comment on it. You are also welcome to share this blog, so that more people can participate in it. If the images used in the blog infringe your copyright, please contact the author to delete them. Thank you!