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

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
>

MS SQL Parelleism

Hello all,

i have two node cluster, each server has 4 dual core processors (16 virtuals) and 16 GB of RAM.
I have to examine if MS SQL Server process is executed by more than one of processor (SQL batchs ect) because i have message of bad working antivirus software whitch blocs multiprocessor execution.

Have anybody idea how can i proof multiproccesor execution ?

Thank you

Regards

Quote:

Originally Posted by Hermess

Hello all,

i have two node cluster, each server has 4 dual core processors (16 virtuals) and 16 GB of RAM.
I have to examine if MS SQL Server process is executed by more than one of processor (SQL batchs ect) because i have message of bad working antivirus software whitch blocs multiprocessor execution.

Have anybody idea how can i proof multiproccesor execution ?

Thank you

Regards

I don't know of a way to "prove" multiprocessor execution, however, you can check your Processor control settings in Enterprise Manager, and watch the individual CPU usage with Task Manager.