Running SQLServer 2000 32bit on 64bit server

[BootMeUp]

We are planning to install 64bit servers, running Windows 2003 server 64bit, using SQLServer 2000 32bit edition.

Has anyone been able to do this successfully? If so, were any adjustments/tuning necessary when and after installing SQLServer 2000 32bit on a 64bit server? Additionally, was there a noticable performance improvement?

We will also have 32bit Windows 2000 servers, running SQLServer 2000 32bit, which will need to function with the 64bit servers. Has anyone had this mix of servers operating successfully?

Thanks for any information,
Steve

 

[mrdenny]

We did some 32bit/64bit performance testing. On regular database operations the 32bit server way out performed the 64bit server. The only time the 64bit server outperformed the 32bit server was when we were doing very advanced math.

By regular database operations I'm talking about single record inserts, updates, deletes, and selects.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mrdenny]

Also there's no problem having a 32bit server talk to a 64bit server. Neither one will know that the other is a different platform.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com