Sql-server – how to configure SQL Server max memory usage

sql serversql-server-2008

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

Best Answer

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.

Related Topic