MSSQL For 64-Bit OS (Windows 2003 64-Bit)

[kenzo]

Is there anyway We could install a MSSQL server 2000 32-Bit in the Windows 2003 Server 64-Bit? Or Any Solution? Or is there any Evaluation Copy we could get from microsoft of 64-bit MSSQL Server? Please help i am lost in 64-Bit MSSQL. Coz my company recently upgraded to 64-bit Windows 2003 sit on a Itatium 2

[skhanal]

MS has all the information you need at

http://www.microsoft.com/sql/64bit/default.asp


Yes, it is possible to run 32 bit SQL on Windows 2003.

[rmiao]

It's possible but you don't get 64-bit performance, may even worse.

[skhanal]

It's possible but you don't get 64-bit performance, may even worse

Not according to microsoft

http://www.microsoft.com/sql/techinf...03benefits.asp

Also see SQL Magazine article (Commentary section)

http://www.sqlmag.com/Articles/Index...rticleID=39073

[rmiao]

I mean you even get worse performance if run 32-bit apps on 64-bit os. Better to run 64-bit sql2k on 64-bit os.

[skhanal]

Even 32 bit applications will benefit because of better CPU and IO management.

[rmiao]

Windows 64-bit version runs 32-bit apps in subsystem that emulates 32-bit environment, may cause performance hit.