64bit SQL

15 Mar 2006 9:23 AM

stevanflores

Hi,

Can anyone confirm that the 64bit edition on SQL 2000 will only run on
Itanium 64 bit machines & not Xeon 64 bit processors?

Is there an Microsoft article on this?

Regards

Steve

15 Mar 2006 9:28 AM

Tibor Karaszi

Confirmed.
(Don't know about MS article, haven't searched KB..)

On EM64T and 64 bit OS, you can run 32 bit SQL Server with sp4 in WOW, which is supported, but
probably not what you want.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

<stevanflo***@gmail.com> wrote in message

Show quoteHide quote

news:1142414594.177552.235650@z34g2000cwc.googlegroups.com...
> Hi,
>
> Can anyone confirm that the 64bit edition on SQL 2000 will only run on
> Itanium 64 bit machines & not Xeon 64 bit processors?
>
> Is there an Microsoft article on this?
>
> Regards
>
> Steve
>

15 Mar 2006 9:34 AM

Uri Dimant

Hi
Yes , 64bit runs on Itanium , but I don't remember the specific article
about that

<stevanflo***@gmail.com> wrote in message
Show quoteHide quote

news:1142414594.177552.235650@z34g2000cwc.googlegroups.com...
> Hi,
>
> Can anyone confirm that the 64bit edition on SQL 2000 will only run on
> Itanium 64 bit machines & not Xeon 64 bit processors?
>
> Is there an Microsoft article on this?
>
> Regards
>
> Steve
>

15 Mar 2006 9:40 AM

Stevan

Thank you both.

We have a 32 bit application that is supposed be getting installed onto
64bit Server 2003, seeing as that we are still going to be using 32bit
SQL 2000, do you think it would be better for us to use the 32bit
version of Windows 2003?

Regards,

Steve

15 Mar 2006 12:05 PM

Enric

IAE64 supports fully 64 bit and partially 32. Before this there was x64
allowing both architectures. As far as I know benefits (64) are visible when
you have more than 4 Gb RAM or 16 processors.

--
current location: alicante (es)

Show quoteHide quote

"Stevan" wrote:

> Thank you both.
>
> We have a 32 bit application that is supposed be getting installed onto
> 64bit Server 2003, seeing as that we are still going to be using 32bit
> SQL 2000, do you think it would be better for us to use the 32bit
> version of Windows 2003?
>
> Regards,
>
> Steve
>
>

15 Mar 2006 12:10 PM

Andrew J. Kelly

You should really look into using SQL2005 since you can run the 64 bit
edition of 2005 on Win2003 X64. But if you stay with 2000 then the 32 bit
is the only choice and it will run just fine on X64.

--
Andrew J. Kelly SQL MVP

Show quoteHide quote

"Stevan" <stevanflo***@gmail.com> wrote in message
news:1142415651.698599.131360@e56g2000cwe.googlegroups.com...
> Thank you both.
>
> We have a 32 bit application that is supposed be getting installed onto
> 64bit Server 2003, seeing as that we are still going to be using 32bit
> SQL 2000, do you think it would be better for us to use the 32bit
> version of Windows 2003?
>
> Regards,
>
> Steve
>

15 Mar 2006 2:27 PM

Linchi Shea

You can certainly run SQL2000 SP4 on Windows 2003 x64. And there are some
benefits right away. For instance, SQL2000 gets to use 4GB by default.
Whether these benefits will bobble up to your app level is a different story.
The only way to determine whether using Windows 2003 x64 will provide better
performance for your app is for you to conduct some tests. For the workloads
I have tested, I get better performance on Windows 2003 x64 for some
workloads and no change in performance for the others >with Windows 2003 x86
vs x64 being the only variable<.

Linchi

Show quoteHide quote

"Stevan" wrote:

> Thank you both.
>
> We have a 32 bit application that is supposed be getting installed onto
> 64bit Server 2003, seeing as that we are still going to be using 32bit
> SQL 2000, do you think it would be better for us to use the 32bit
> version of Windows 2003?
>
> Regards,
>
> Steve
>
>

16 Mar 2006 7:24 PM

David Gugick

stevanflo***@gmail.com wrote:

> Hi,
>
> Can anyone confirm that the 64bit edition on SQL 2000 will only run on
> Itanium 64 bit machines & not Xeon 64 bit processors?
>
> Is there an Microsoft article on this?
>
> Regards
>
> Steve

64-bit IA64 Itanium is your only 64-bit option for SQL Server 2000 and
it must run on equivalent Itanium hardware.

SQL Server 2005 supports three platforms: x86, x64 (AMD64 and Intel
EM64T), and Itanium

You can run SQL Server 2000 SP4 x86 and SQL Server 2005 x86 on Windows
Server 2003 x64 Edition.

--
David Gugick - SQL Server MVP
Quest Software