Friday, March 30, 2012

MS SQL Standard Edition Memory.

I understand that MS SQL Standard Edition has a 2GB memory
limit. Windows 2000 server supports 4GB of memory. My
hardware supports two processors. If I license per
Processor method and install two processors and license
two Standard editions will there be 2GB of memory per
processor or 2GB for both processors?
Thanks2GB address space is per SQLServer process(sqlserver.exe). It is nothing to
do with the processor. You can increase the SQLServer address space by
setting /3GB switch in boot.ini
This will leave just 1 GB for OS. May interfere with some of your video
drivers
-kumar
"ddavids@.idfbins.com" wrote:
> I understand that MS SQL Standard Edition has a 2GB memory
> limit. Windows 2000 server supports 4GB of memory. My
> hardware supports two processors. If I license per
> Processor method and install two processors and license
> two Standard editions will there be 2GB of memory per
> processor or 2GB for both processors?
> Thanks
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0016_01C4AB13.8A8C37F0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Beware that Sql server 2000 standard edition does not support /3gb =switch. This is only supported in Sql server 2000 enterprise edition.
Tunji
"Kumar Part" <Kumar Part@.discussions.microsoft.com> wrote in message =news:8E572684-C9AE-4679-BC12-4B56003EB4B8@.microsoft.com...
2GB address space is per SQLServer process(sqlserver.exe). It is =nothing to do with the processor. You can increase the SQLServer address space by =
setting /3GB switch in boot.ini
This will leave just 1 GB for OS. May interfere with some of your =video drivers
-kumar
"ddavids@.idfbins.com" wrote:
> I understand that MS SQL Standard Edition has a 2GB memory > limit. Windows 2000 server supports 4GB of memory. My > hardware supports two processors. If I license per > Processor method and install two processors and license > two Standard editions will there be 2GB of memory per > processor or 2GB for both processors?
> > Thanks > >
--=_NextPart_000_0016_01C4AB13.8A8C37F0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Beware that Sql server 2000 standard =edition does not support /3gb switch. This is only supported in Sql server 2000 =enterprise edition.
Tunji
"Kumar Part" wrote in message news:8E5=72684-C9AE-4679-BC12-4B56003EB4B8@.microsoft.com...
2GB address space is per SQLServer process(sqlserver.exe). It is nothing =to do with the processor. You can increase the SQLServer address space by setting /3GB switch in boot.iniThis will leave just 1 GB =for OS. May interfere with some of your video =drivers-kumar"ddavids@.idfbins.com" =wrote:> I understand that MS SQL Standard Edition has a 2GB memory > limit. Windows 2000 server supports 4GB of memory. My => hardware supports two processors. If I license per > =Processor method and install two processors and license > two Standard =editions will there be 2GB of memory per > processor or 2GB for both processors?> > Thanks > >

--=_NextPart_000_0016_01C4AB13.8A8C37F0--

No comments:

Post a Comment