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 1

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
2  
+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
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.