Setting Limits on Memory for SQL Express 1

[boardgamer]

I am running SQL Express. I have been having problem with memory usage. Someone on one of the other forums suggested that there is a way to put a cap on the memory it comsumes. Can you help me?

 

[gmmastros]

You want to be a little careful with limiting the memory because it can have a dramatic effect on performance.

I don't have SQL Express installed (I have SQL Standard).

To limit the memory usage....

Open SQL Server Management Studio (express).
Right click your server name
Click Properties
On the 'Select a page' part, click Memory.
Change the "Maximum server memory" setting.

If you don't have SQL Server Management Studio Express, it's a free download from Microsoft. A quick google search should find it.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[baddos]

If you don't have any management guis to do this, you can use this example to do it.

http://support.microsoft.com/kb/909636

 

[SQLWilts]

FYI
SQL Express only uses 1GB of memory anyway - personally I wouldn't restrict it down any further than that...