Yes, increasing or changing your virtual memory will have. And, as Indy alluded to moving it to a separate drive, not just a different partition is useful.
The rule of thumb is always 1.5 times the physical RAM, so you would change it in My Computer properties. Virtual memory will allow the Windows to free up some physical RAM by paging or "swapping" the memory. Anytime this happens you will be experiencing system degradation.
I would suggest setting the initial virtual memory the same as the maximum. Also, some will tell you to leave a small amount of VM on the C: drive such as 4Mb to 10Mbs.
I am not sure that 4GB is exploding. You would set it to 3GB anyway. In your case maybe less such as 2GBs. Make SURE that on the window where you set your VM, that you select best performance for background services.
Setting a maximum for SBS monitoring, given that SQL as a whole is managing its own memory, it will just start storing pages and procedures from AC. Of course, you are right that with more physical memory, even if you let Workgroup do its own thing, you would still have the 1GB. The problem is SQL will take its 3GB and you will be left with 300Mbs given the limit of a 32-bit OS.
Still, I would add 2GB of RAM tomorrow. By 7 am
This would be the single best thing you can do to improve performance. You stated you have 28 clients. Everything will run better with more RAM.
Not being a SQL expert, I am not sure if 150MBs will be sufficient. I am not sure.
How much space did you set up the C: drive to begin with. You can always increase its size with a partition manager for servers, but I would back up everything first.
I am guessing you set your mins and maxs using SSMS? You would likely need to set ACs as well.
How feasible is it for you to move to SBS 2008 or Windows Server 2008? Of course, you could still install a 64-bit 2003 OS, but if you were going to change, then you may as well upgrade to 2008. It's a sweet OS. Then, of course, you are only limited by the hardware up to the 64GB limit. Dell gave me some RAM, so I installed 20GBs, which is overkill, but 8 to 12 GBs of RAM would definitely solve your problem.
If you need a SQL guru, let me know.
You can probably clear off some of that space on the C: drive. Temp files and Windows Updates restore files take up mega room. Do a search for .tmp and see what shows up. Also, Google a free program called TreeSize Free. This program will show you exactly what is taking up what space on your PC. Finally, do you empty your Recycle Bin? Sometimes, I forget after I delete large files from the bin, and it is still taking up space.
HTH. Let me know.
Indy's suggestion on the SSD is a good one, but I am not very familiar with that one.
