3GB once again

Hi,
No there is no memory Limit for SQL Standard edition.. Using SP_CONFIGURE enable the option 'AWE Enabled' by setting the value to 1. After that set the max server memory
value to 3 GB for your SQL Server.
Thanks
Hari
"Axel Bender" <axel_bender@.t-online.de> wrote in message news:eq76ee$unj$00$1@.news.t-online.com...
Hi,
In the following configuration:
- SQL Server 2005 Standard SP1
- Windows 2003 Server R2 Standard
- 4 GB physical memory
- /3GB and /UserVA=3072 in boot.ini
the maximum amount of memory I can configure SQL Server to use (Options dialog) is 2 GB.
I found contradictory statements in the Web (see below) as well as in the MS SQL Server docs (limited by OS memory) for the Standard Edition.
Is there a 2 GB limit for SQL Server 2005 Standard on Windows 2003 Server?
thx
Axel
Hari
It is correct to 32 bit version as I understood . For 64 bit version you have to grant permission to the account on Lock Page memory and there is not reason to enable AWE.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message news:OQf$TaSSHHA.4260@.TK2MSFTNGP06.phx.gbl...
Hi,
No there is no memory Limit for SQL Standard edition.. Using SP_CONFIGURE enable the option 'AWE Enabled' by setting the value to 1. After that set the max server memory
value to 3 GB for your SQL Server.
Thanks
Hari
"Axel Bender" <axel_bender@.t-online.de> wrote in message news:eq76ee$unj$00$1@.news.t-online.com...
Hi,
In the following configuration:
- SQL Server 2005 Standard SP1
- Windows 2003 Server R2 Standard
- 4 GB physical memory
- /3GB and /UserVA=3072 in boot.ini
the maximum amount of memory I can configure SQL Server to use (Options dialog) is 2 GB.
I found contradictory statements in the Web (see below) as well as in the MS SQL Server docs (limited by OS memory) for the Standard Edition.
Is there a 2 GB limit for SQL Server 2005 Standard on Windows 2003 Server?
thx
Axel