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
Showing posts with label improvement. Show all posts
Showing posts with label improvement. Show all posts
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
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
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
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
Subscribe to:
Posts (Atom)