We're going to be switching from Windows Server 2008 Standard (32-bit)
to Windows Server 2008 Standard (64-bit) over the next few months.
This is primarily so that we can make use of the additional RAM
capabilities.

We have SQL Server 2008 Standard (x86 and x64) which will run on the
server.

Is there a maximum amount of RAM that SQL Server Standard can "see"?
I wouldn't want to be running a 64-bit o/s with 16GB RAM only to find
that SQL can't make use of it all.

thanks in advance!

Both will use the "Operating system maximum" memory.
http://msdn.microsoft.com/en-us/library/ms143506.aspx

But since x86 runs in WOW64 (Windows on Windows) 32-bit support, it is
limited to 4GB of RAM of standard memory. In addition, the last two links
say that AWE is available to WOW64, so you can use that feature as well to
increase the RAM available in 32-bit SQL Server. (But I have not tried it.)
http://msdn.microsoft.com/en-us/library/ms187499.aspx

AWE with WOW64
http://blogs.technet.com/efleis/arch...22/408112.aspx
http://support.microsoft.com/kb/896456

RLF

"BadBoy House" <mrchrishouse (AT) googlemail (DOT) com> wrote

Why would you want to run both x86 & x64 bit sql on the same box?

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"BadBoy House" <mrchrishouse (AT) googlemail (DOT) com> wrote