Can 32 bit SQL 2005 run on a 64 bit processor?

I'm going to be buying a new home PC, and am realizing that many of them now
come in 64 bit. I will of course want to install SQL 2005, but my copy is 32
bit. Also, my copy of Windows XP Pro is 32 bit as well. Should these things
be OK on a 64 bit box?SQL Server depends on the OS architecture. So, if you are running as 32-bit
OS then the 32-bit version of SQL Server is just fine. Even if you upgrade
your OS to 64-bit you can still use the 32-bit version of SQL Server using
Windows-on-Windows. Also, XP Pro 32-bit will work fine on 64-bit processors.
However, the 32-bit OS cannot take advantage of the 64-bit hardware so you
might look into upgrading to XP 64-bit.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"ChrisR" <ChrisR@.NoEmail.com> wrote in message
news:epmRRSrIHHA.1504@.TK2MSFTNGP03.phx.gbl...
> I'm going to be buying a new home PC, and am realizing that many of them
> now come in 64 bit. I will of course want to install SQL 2005, but my copy
> is 32 bit. Also, my copy of Windows XP Pro is 32 bit as well. Should these
> things be OK on a 64 bit box?
>|||Awesome, thanks!
"Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
news:O6ea6xrIHHA.1504@.TK2MSFTNGP03.phx.gbl...
> SQL Server depends on the OS architecture. So, if you are running as
> 32-bit OS then the 32-bit version of SQL Server is just fine. Even if you
> upgrade your OS to 64-bit you can still use the 32-bit version of SQL
> Server using Windows-on-Windows. Also, XP Pro 32-bit will work fine on
> 64-bit processors. However, the 32-bit OS cannot take advantage of the
> 64-bit hardware so you might look into upgrading to XP 64-bit.
> Regards,
> Plamen Ratchev
> http://www.SQLStudio.com
>
> "ChrisR" <ChrisR@.NoEmail.com> wrote in message
> news:epmRRSrIHHA.1504@.TK2MSFTNGP03.phx.gbl...
>> I'm going to be buying a new home PC, and am realizing that many of them
>> now come in 64 bit. I will of course want to install SQL 2005, but my
>> copy is 32 bit. Also, my copy of Windows XP Pro is 32 bit as well. Should
>> these things be OK on a 64 bit box?
>|||Hi Chris,
Yes, you can run 32-bit SQL Server on an x64 platform.You can't run
32-bit SQL Server, however, on an Itanium-based platform. The biggest
advantage to running under 64-bit is that you won't have to enable AWE
with the /3GB switch (and /PAE switch on W2K OS). However, you'll
still be limited to 3 GB of RAM for base memory if you're using SQL
Server 2000. If you're using SQL Server 2005 base memory increases to
4 GB unless you're also installing support for CLR, in which case
you'll only have 3 GB for base memory.
You can install XP Pro on an x64 platform as well, but you won't be
able to take advantage of any of the 64-bit functionality mentioned
above. For that, you'll have to spend the bucks to get the 64-bit
version of Windows 2003 Enterprise Edition.
So if all you've got is XP Pro and you plan to install 32-bit
2000/2005, you'd be better off sticking with a 32-bit platform like
the Intel Core Duo. also, if you plan to use this machine as a
database server (as opposed to development) then I'd also suggest
turning off hyperthreading. At high CPU usage the extra work required
to operate the logical CPUs actually decreases overall system
performance.
On Mon, 18 Dec 2006 07:55:26 -0800, "ChrisR" <ChrisR@.NoEmail.com>
wrote:
>I'm going to be buying a new home PC, and am realizing that many of them now
>come in 64 bit. I will of course want to install SQL 2005, but my copy is 32
>bit. Also, my copy of Windows XP Pro is 32 bit as well. Should these things
>be OK on a 64 bit box?
>