/3GB not working

hello,
physically I have 8GB RAM in a dell server running windows 2003 server and
SQL 2005 developer edition. the OS only sees 4GB and SQL only uses 2 GB. I
have recently found out I need to be using either 64bit, enterprise or data
center versions to access >4GB of ram but there should be no reason for me
not to use 3 of the 4GB for SQL. I have enabled /3GB after the fastdetect
line in boot.ini but SQL still uses only 2 GB. I checked the max-memory
setting and its at the default 2billion+ MB.

does anyone know of any other reason that SQL 2005 developer edition won't
use more than 1.8 GB? this box has only 2 other apps running which use under
50 MB of RAM combined.

Leon

I made an error in the earlier post. the server is running SQL 2008
developer edition on Windows 2003 R2.

Leon

Hello Leon,

If the Windows server 2003 is Standard edition, you are limited to 4GB RAM,
only if 64bit version is used, up to 32GB RAM is possible, so please confirm
about this.

Best regards

Meinolf Weber
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
no rights.
** Please do NOT email, only reply to Newsgroups
** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.htm


> hello,
> physically I have 8GB RAM in a dell server running windows 2003 server
> and
> SQL 2005 developer edition. the OS only sees 4GB and SQL only uses 2
> GB. I
> have recently found out I need to be using either 64bit, enterprise or
> data
> center versions to access >4GB of ram but there should be no reason
> for me
> not to use 3 of the 4GB for SQL. I have enabled /3GB after the
> fastdetect
> line in boot.ini but SQL still uses only 2 GB. I checked the
> max-memory
> setting and its at the default 2billion+ MB.
> does anyone know of any other reason that SQL 2005 developer edition
> won't use more than 1.8 GB? this box has only 2 other apps running
> which use under 50 MB of RAM combined.
>
> Leon
>

yes it is 32 bit 2003 standard so i know i'm limited to 4GB. My question is
why doesn't the /3GB allow me to use 3 gig of ram?

Leon


"Meinolf Weber [MVP-DS]" <meiweb@(nospam)gmx.de> wrote in message
news:. com...
> Hello Leon,
>
> If the Windows server 2003 is Standard edition, you are limited to 4GB
> RAM, only if 64bit version is used, up to 32GB RAM is possible, so please
> confirm about this.
>
> Best regards
>
> Meinolf Weber
> Disclaimer: This posting is provided "AS IS" with no warranties, and
> confers no rights.
> ** Please do NOT email, only reply to Newsgroups
> ** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.htm
>
>> hello,
>> physically I have 8GB RAM in a dell server running windows 2003 server
>> and
>> SQL 2005 developer edition. the OS only sees 4GB and SQL only uses 2
>> GB. I
>> have recently found out I need to be using either 64bit, enterprise or
>> data
>> center versions to access >4GB of ram but there should be no reason
>> for me
>> not to use 3 of the 4GB for SQL. I have enabled /3GB after the
>> fastdetect
>> line in boot.ini but SQL still uses only 2 GB. I checked the
>> max-memory
>> setting and its at the default 2billion+ MB.
>> does anyone know of any other reason that SQL 2005 developer edition
>> won't use more than 1.8 GB? this box has only 2 other apps running
>> which use under 50 MB of RAM combined.
>>
>> Leon
>>
>
>

Hello Leon,

As far as i nknow the /3GB doesn't work in 2003 Standard edition.

Best regards

Meinolf Weber
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
no rights.
** Please do NOT email, only reply to Newsgroups
** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.htm


> yes it is 32 bit 2003 standard so i know i'm limited to 4GB. My
> question is why doesn't the /3GB allow me to use 3 gig of ram?
>
> Leon
>
> "Meinolf Weber [MVP-DS]" <meiweb@(nospam)gmx.de> wrote in message
> news:. com...
>
>> Hello Leon,
>>
>> If the Windows server 2003 is Standard edition, you are limited to
>> 4GB RAM, only if 64bit version is used, up to 32GB RAM is possible,
>> so please confirm about this.
>>
>> Best regards
>>
>> Meinolf Weber
>> Disclaimer: This posting is provided "AS IS" with no warranties, and
>> confers no rights.
>> ** Please do NOT email, only reply to Newsgroups
>> ** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.htm
>>> hello,
>>> physically I have 8GB RAM in a dell server running windows 2003
>>> server
>>> and
>>> SQL 2005 developer edition. the OS only sees 4GB and SQL only uses 2
>>> GB. I
>>> have recently found out I need to be using either 64bit, enterprise
>>> or
>>> data
>>> center versions to access >4GB of ram but there should be no reason
>>> for me
>>> not to use 3 of the 4GB for SQL. I have enabled /3GB after the
>>> fastdetect
>>> line in boot.ini but SQL still uses only 2 GB. I checked the
>>> max-memory
>>> setting and its at the default 2billion+ MB.
>>> does anyone know of any other reason that SQL 2005 developer edition
>>> won't use more than 1.8 GB? this box has only 2 other apps running
>>> which use under 50 MB of RAM combined.
>>> Leon
>>>

Should be working.

http://technet.microsoft.com/en-us/l...EXCHG.65).aspx




--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Meinolf Weber [MVP-DS]" wrote:
> Hello Leon,
>
> As far as i nknow the /3GB doesn't work in 2003 Standard edition.
>
> Best regards
>
> Meinolf Weber

Hello Dave,

Thanks for the clarification. Will keep this in mind. :-)

Best regards

Meinolf Weber
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
no rights.
** Please do NOT email, only reply to Newsgroups
** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.htm


> Should be working.
>
> http://technet.microsoft.com/en-us/l...EXCHG.65).aspx
>
> Dave Patrick ....Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Meinolf Weber [MVP-DS]" wrote:
>
>> Hello Leon,
>>
>> As far as i nknow the /3GB doesn't work in 2003 Standard edition.
>>
>> Best regards
>>
>> Meinolf Weber
>>