Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am using SQL Server 2008 Enterprise. SQL Server 2008 always tries to eat as much as memory as it could. Any ways to configure per database or per instance or per server level max memory usage of SQL Server 2008?

thanks in advance, George

share|improve this question
add comment

1 Answer

up vote 4 down vote accepted

You can configure the max usage for a SQL instance in Management Studio by right-clicking on the relevant instance in Object Explorer, choosing properties, then Memory, and choosing your maximum, as detailed here :

http://msdn.microsoft.com/en-us/library/ms191144.aspx

However, it's generally not necessary to do this unless your other apps or instances are actually having problems getting memory. Simply seeing that the server appears to have no free RAM is not a problem in itself, but normal behaviour.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["        <li><a href=\"http://area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"http://careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2014 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2014.4.23.1561\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Server Fault works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class=\"dno\"></div>\r\n    </noscr"], "copyright__copyright__copyright": ["en-us/library/ms191144.aspx\n\nHowever, it's generally not necessary to do this unless your other apps or instances are actually having problems getting memory. Simply seeing that the server appears to have no free RAM is not a problem in itself, but normal behaviour.\n\nshare|improve this answer\nadd comment\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service.\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}