Virtual Memory

[maya14]

We have a 4 GB RAM SBS box with Page File on C drive. Virtual Memory size set as 2046 - 4092.
We have SQL installed and it seems that SQL processes are using maximum memory. Server are frequently low on virtual memory.
How can I correct the problem?

 

[ShackDaddy]

It's normal to see your SQL taking up a lot of memory. It pre-allocates all the memory it might need, so you'll always see it use a lot and probably not fluctuate much. There are ways to change that amount. The method depends on whether you are running SBS Premium with SQL or just SBS Standard with the SQL MSDE.

To resolve your virtual memory issue, I would set your page file to be about 6gb. Set the max and min size to be the same so that it will reduce fragmentation on your drive and increase read efficiency.

ShackDaddy
Shackelford Consulting

 

[LWComputingMVP]

Maximum pagefile size is 4 GB - put another pagefile on another disk (preferrably) or partition. In addition, you can stop and restart the SQL Services and that should free up some memory. Lastly, you can control the amount of RAM the MSDE processes use - see Danny28's comments in this thread:

http://www.tek-tips.com/viewthread.cfm?qid=1350635

 

[maya14]

We using SBS Premium with SQL. So should I still set page file to 6gb min and max on C drive or should I create another page file on a separate drive or partition?
The problem is when it hits low virtual memory it disconnects some resources according to the error message.

 

[ShackDaddy]

Set the Min-Max to 4gb on C: and make a new 2gb page file on another disk. Set the min-max to 2gb.

Using the SQL management tools, you should be able to set the amount of memory dedicated to SQL. Usually the default settings are best though.

ShackDaddy
Shackelford Consulting

 

[LWComputingMVP]

ShackDaddy - What SQL management tools would you be talking about?

 

[LWComputingMVP]

Nevermind, I thought this was SBS Standard.

 

[maya14]

Thanks for advice so far. For a quick fix i rebooted the server but will follow the advice and create page file of 4 GB on C drive and another on seperate drive with 2 GB.
I thought the max was 4 GB in total for page file??

 

[LWComputingMVP]

I cannot locate the MS article, but the maximum number of pagefiles is 16, each of 4 GB or less and each on a separate logical drive.