64 Bit SQL server

Is it ok to run 32-bit sql server on 64-bit windows 2003 os? Is there
performance improvement , same or decerase?
Can I attach 64bit sql 2000 user database to 32bit sql 2000?
Thanks for your help in advance.
"MPatel" <MPatel@.discussions.microsoft.com> wrote in message
news:BB62673E-3CFC-4772-BACA-3672106AF567@.microsoft.com...
> Is it ok to run 32-bit sql server on 64-bit windows 2003 os?
32-bit SQL Server 2000 SP 4 is supported on WOW (Windows on Windows64),
which is 32-bit runtime for 64-bit Windows (x64). x64, not Itanium.

>Is there performance improvement , same or decerase?
The x64 chips have hardware support for this, so it's pretty efficient.
Switching back and forth from 64-bit to 32-bit is just another CPU mode
switch, like the transition from user-mode to kernel-mode which happens on
32-bit Windows whenever you access OS resources.
So performance should be about the same. SQL Server 2000 Enterprise Edition
will be able to use 4GB of ram without the /3GB switch or AWE enabled. This
is because on 64-bit Windows all kernel-mode code must run in 64-bit mode.
A side-effect of this is that a WOW process gets the whole 4GB of 32-bit
addressable space to use for programs.

> Can I attach 64bit sql 2000 user database to 32bit sql 2000?
This isn't 64bit SQL Server, it's 32bit SQL Server running on 64-bit
Windows. But to answer your question, the data file formats are the same
regardless of the CPU architecture.
David