Re: There is a trick to change this ratio to 1 GB OS, 3 GB App that Microsoft supports for running SQL Server on the Server OS.
Yeah, it's called the "pay Microsoft $750 for the 3GB version of the kernel that comes in advanced server" trick.
:-(
I hate that trick - too expensive....
If you're running multiple processes, you will be able to use more than 2GB, but hardware takes 1GB no matter what version of windows you're running.
Might as well just buy an Athlon 64 or Opteron. They don't cost any more than equivalent Pentiums, will do anything the Pentium will do (except heat the room) and they offer so much more!
:-)