Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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 :

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
+1, and I'd like to add that SQL should be running on its own box. It is designed to use as much memory as it can to make things faster. – user3914 Sep 25 '09 at 7:47
Great answer, thanks! – George2 Sep 25 '09 at 8:13

Your Answer


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.