/3GB and Maximum server memory

Hi,
I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
activated the /3GB switch in the boot.ini, but I still can't setthe Maximum
server memory any higher than 2147483647. What should I do else? I presume I
should be able to set it until 3 gigabytes now?
Any help will be really appreciated,
Thansk a lot in advance,
Pieter
This is my boot.ini:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard"
/noexecute=optout /fastdetect /3GBWith /3GB switch alone, you should be able to see SQLServer:Buffer
Manager\Total Pages or SQLServer:Memory Manager\Total Server Memory
(KB)--both measuring the buffer pool--reach more than 2GB. But you probably
won't see the buffer pool reach 3GB. Maybe, you didn't drive the SQL instance
hard enough for it to use more than what you reported.
See
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx for an exmaple.
BTW, how did you get the 2147483647 number?
Linchi
"Pieter" wrote:
> Hi,
> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
> activated the /3GB switch in the boot.ini, but I still can't setthe Maximum
> server memory any higher than 2147483647. What should I do else? I presume I
> should be able to set it until 3 gigabytes now?
>
> Any help will be really appreciated,
>
> Thansk a lot in advance,
>
> Pieter
> This is my boot.ini:
> [boot loader]
> timeout=30
> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard"
> /noexecute=optout /fastdetect /3GB
>
>|||IIRC, that setting is in MEGABYTES, so it is far more than 4GB. :) Also,
you really should set the limit for this to about 2.5-3GB to keep from
starving the OS and other necessary items of RAM.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Pieter" <pieterNOSPAMcoucke@.hotmail.com> wrote in message
news:u5h1fb6mIHA.3636@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
> activated the /3GB switch in the boot.ini, but I still can't setthe
> Maximum server memory any higher than 2147483647. What should I do else? I
> presume I should be able to set it until 3 gigabytes now?
>
> Any help will be really appreciated,
>
> Thansk a lot in advance,
>
> Pieter
> This is my boot.ini:
> [boot loader]
> timeout=30
> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003,
> Standard" /noexecute=optout /fastdetect /3GB
>|||Hi,
Indeed: In the mean time (when looking at the Task Manager) SQL Server is
using allmost 3 gigabytes, which is perfect!
Regarding the 2147483647: when you right click on the Server in the SQL
Server Management Studio, choose properties, and than Memory, you see the
Maximum server memory. But I guess it has nothing to do with it :-)
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:8DEA94EC-ACD9-4C2F-8C93-FE8B24FF7F94@.microsoft.com...
> With /3GB switch alone, you should be able to see SQLServer:Buffer
> Manager\Total Pages or SQLServer:Memory Manager\Total Server Memory
> (KB)--both measuring the buffer pool--reach more than 2GB. But you
> probably
> won't see the buffer pool reach 3GB. Maybe, you didn't drive the SQL
> instance
> hard enough for it to use more than what you reported.
> See
> http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx
> for an exmaple.
> BTW, how did you get the 2147483647 number?
> Linchi
> "Pieter" wrote:
>> Hi,
>> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
>> activated the /3GB switch in the boot.ini, but I still can't setthe
>> Maximum
>> server memory any higher than 2147483647. What should I do else? I
>> presume I
>> should be able to set it until 3 gigabytes now?
>>
>> Any help will be really appreciated,
>>
>> Thansk a lot in advance,
>>
>> Pieter
>> This is my boot.ini:
>> [boot loader]
>> timeout=30
>> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
>> [operating systems]
>> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003,
>> Standard"
>> /noexecute=optout /fastdetect /3GB
>>