Which would make complete sense as the OS generally sees the 3.2GBs exactly.

Tom is completely correct. While XP Pro can do 64-bit, that would be a crazy way to go.

The deal is this: In 2011, it is time to switch to 64-bit. As everyone knows, RAM is the most effective way to increase performance in your computer. And, it's dirt cheap. So, you want to add what you want. All of my computers have 8GBs of RAM and the server has 20. Doesn't need 20, but, what the hell, I got a good deal on 16GB of RAM for Dell, and it had four. Eight is a good number and, hey, if you get into trouble, go to NewEgg and get four more.

You can get by on 3.2 GB of RAM if you want to reboot every week which sort of defeats the purpose of letting SQL manage its RAM and obtain page files. I would suggest upgrading to SBS 2008 or 2011 if your processor will handle 64-bit, which it should. Depends on how many users or machines you have for licensing. You also have the choice of Windows Foundation.


Bert
Pediatrics
Brewer, Maine