Saturday, February 25, 2012

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|||"David Browne" wrote:
> "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
>
>
So does that make the info presented in this link incorrect now?
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241693,00.html

No comments:

Post a Comment