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?
Thanks
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
>
|||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
>