SQL 2005 RAM utilization governing/capping

[joepc]

Does anyone know of a way on how to govern/cap the amount of RAM that SQL 2005 standard uses. I have a server that has most of it's RAM being consumed by SQL and it is starting to effect other programs on the server.

Thanks in advance!

 

[kodaksmile]

You can set the maximum memory that can be used by sql - in management studio, right click on the instance name, go to properties, memory and set the max memory allowed in mb.

 

[mrdenny]

Or you can use sp_configure to set the setting.

exec sp_configure 'max server memory', 2048 /*Amount in Megs*/
reconfigure

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog