I have a server where sqlserver.exe is using 13.5GB of 16GB of the
available memory available on the server. I want to limit this to 8GB
of RAM that the sqlserver can use, it is clogging things up and
pegging the processor on a regular basis. Is there a setting or a web
site i can be pointed to so in can chance the config on this.

markcmh60 (mark6960 (AT) yahoo (DOT) com) writes:
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
EXEC sp_configure 'max server memory', 8192
RECONFIGURE

However, note that it is perfectly normal for SQL Server to grab all
memory it can. By having data in the buffer cache, SQL Server can
perform much better. If you have no other applications running on the
server, you should definitely not set the limit as low as 8 MB.

If you have problems with SQL Server taking a lot at CPU at times, you
probably have queries that could benefit from some tuning.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

On 2012-02-07 22:53, Erland Sommarskog wrote:
get by with only a few hundred MB, but I don't think you could get it down
to 8. :-)

--
J.