32bit sql on 64bit windows?

We have new servers with 16GB RAM. I want the OS and SQL to use as much of it
as possible. I can't put 64bit SQL on the box because the vendor doesn't
support that. Can I install 64bit 2003 and 32bit SQL 2000? If so, will SQL be
able to use all of the memory or just the OS?
Thanks
Roger"Roger" <Roger@.discussions.microsoft.com> wrote in message
news:8796554C-FC5D-44F4-A150-2E867AA9F7AB@.microsoft.com...
> We have new servers with 16GB RAM. I want the OS and SQL to use as much of
> it
> as possible. I can't put 64bit SQL on the box because the vendor doesn't
> support that. Can I install 64bit 2003 and 32bit SQL 2000? If so, will SQL
> be
> able to use all of the memory or just the OS?
>
SQL Server 2000 SP4 is supported on Windows Server 2003 x64 Edition. SQL
Server 2000 Standard Edition is limited to 2GB of RAM. SQL Server 2000
Enterprise Edition on 64bit Windows can use 4GB of ram without AWE, and can
use more with AWE.
David|||Interesting...
May I ask, how you go about setting up AWE in a 64-bit Windows? Does it need
to be set up from Windows side? Or is it just one needs to do sp_configure
'awe enabled', 1, from SQL Server side, will that be sufficient?
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:e8tawkn3GHA.3828@.TK2MSFTNGP06.phx.gbl...
>
> "Roger" <Roger@.discussions.microsoft.com> wrote in message
> news:8796554C-FC5D-44F4-A150-2E867AA9F7AB@.microsoft.com...
>> We have new servers with 16GB RAM. I want the OS and SQL to use as much
>> of it
>> as possible. I can't put 64bit SQL on the box because the vendor doesn't
>> support that. Can I install 64bit 2003 and 32bit SQL 2000? If so, will
>> SQL be
>> able to use all of the memory or just the OS?
> SQL Server 2000 SP4 is supported on Windows Server 2003 x64 Edition. SQL
> Server 2000 Standard Edition is limited to 2GB of RAM. SQL Server 2000
> Enterprise Edition on 64bit Windows can use 4GB of ram without AWE, and
> can use more with AWE.
> David|||Nothing at the OS level, and same thing with sp_configure 'awe enabled' in
SQL Server.
Linchi
"Sean T Shen" wrote:
> Interesting...
> May I ask, how you go about setting up AWE in a 64-bit Windows? Does it need
> to be set up from Windows side? Or is it just one needs to do sp_configure
> 'awe enabled', 1, from SQL Server side, will that be sufficient?
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:e8tawkn3GHA.3828@.TK2MSFTNGP06.phx.gbl...
> >
> >
> > "Roger" <Roger@.discussions.microsoft.com> wrote in message
> > news:8796554C-FC5D-44F4-A150-2E867AA9F7AB@.microsoft.com...
> >> We have new servers with 16GB RAM. I want the OS and SQL to use as much
> >> of it
> >> as possible. I can't put 64bit SQL on the box because the vendor doesn't
> >> support that. Can I install 64bit 2003 and 32bit SQL 2000? If so, will
> >> SQL be
> >> able to use all of the memory or just the OS?
> >>
> >
> > SQL Server 2000 SP4 is supported on Windows Server 2003 x64 Edition. SQL
> > Server 2000 Standard Edition is limited to 2GB of RAM. SQL Server 2000
> > Enterprise Edition on 64bit Windows can use 4GB of ram without AWE, and
> > can use more with AWE.
> >
> > David
>
>|||So, there is no solution for 32bit SQL 2000 Standard Edition to allow more
than 2GB on Windows 2003 Enterprise 64bit environment with AWE setup?
Alex
"Linchi Shea" wrote:
> Nothing at the OS level, and same thing with sp_configure 'awe enabled' in
> SQL Server.
> Linchi
> "Sean T Shen" wrote:
> > Interesting...
> > May I ask, how you go about setting up AWE in a 64-bit Windows? Does it need
> > to be set up from Windows side? Or is it just one needs to do sp_configure
> > 'awe enabled', 1, from SQL Server side, will that be sufficient?
> >
> >
> >
> > "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> > message news:e8tawkn3GHA.3828@.TK2MSFTNGP06.phx.gbl...
> > >
> > >
> > > "Roger" <Roger@.discussions.microsoft.com> wrote in message
> > > news:8796554C-FC5D-44F4-A150-2E867AA9F7AB@.microsoft.com...
> > >> We have new servers with 16GB RAM. I want the OS and SQL to use as much
> > >> of it
> > >> as possible. I can't put 64bit SQL on the box because the vendor doesn't
> > >> support that. Can I install 64bit 2003 and 32bit SQL 2000? If so, will
> > >> SQL be
> > >> able to use all of the memory or just the OS?
> > >>
> > >
> > > SQL Server 2000 SP4 is supported on Windows Server 2003 x64 Edition. SQL
> > > Server 2000 Standard Edition is limited to 2GB of RAM. SQL Server 2000
> > > Enterprise Edition on 64bit Windows can use 4GB of ram without AWE, and
> > > can use more with AWE.
> > >
> > > David
> >
> >
> >|||I am having the same issue. 3 new servers,
Quad DualCore Opteron 880 2.4 gHz w/ 16 GB RAM
Windows 2003 R2 Enterprise x64 Edition SP1
SQL Server 2000 EE SP4
AWE Enabled, 14GB Dynamically allocated to SQL Server
Oddly 2 servers are running just fine, but I can't find the difference to
the 3rd and it will not recognize beyond 3.55GB of memory in SQL Server.
Anyone have any experience with this who could offer any suggestions would
be appreciated.