sql 2005 std increase server memory limit >2GB?

26 Nov 2007 9:03 AM

Piotr Lipski

Hi.

Is there any way of increasing memory available for SQL Server 2005? The
maximum I can set from SSMS is 2GB. There is 4GB server designed
exclusively for SQL databases so I would like to set the memory limit to
3GB (or even more).

SQL Server Standard, 32bit.

--
PL

26 Nov 2007 9:16 AM

Uri Dimant

Hi
You need to put /3GB in the Boot.ini file

[operating systems]
multi(0)disk(0)rdisk(1)partition(2)\WINNT="Microsoft Windows 2000 Server"
/fastdetect /3GB

Show quote

"Piotr Lipski" <p*@mibi.pl> wrote in message
news:fie24u$af1$1@news.onet.pl...
> Hi.
>
> Is there any way of increasing memory available for SQL Server 2005? The
> maximum I can set from SSMS is 2GB. There is 4GB server designed
> exclusively for SQL databases so I would like to set the memory limit to
> 3GB (or even more).
>
> SQL Server Standard, 32bit.
>
> --
> PL

26 Nov 2007 9:51 AM

Piotr Lipski

That worked. Thanks.

--
PL

Uri Dimant wrote:

Show quote

> Hi
> You need to put /3GB in the Boot.ini file
>
> [operating systems]
> multi(0)disk(0)rdisk(1)partition(2)\WINNT="Microsoft Windows 2000 Server"
> /fastdetect /3GB
>
>
>
> "Piotr Lipski" <p*@mibi.pl> wrote in message
> news:fie24u$af1$1@news.onet.pl...
>> Hi.
>>
>> Is there any way of increasing memory available for SQL Server 2005? The
>> maximum I can set from SSMS is 2GB. There is 4GB server designed
>> exclusively for SQL databases so I would like to set the memory limit to
>> 3GB (or even more).
>>
>> SQL Server Standard, 32bit.
>>
>> --
>> PL
>
>

26 Nov 2007 9:18 AM

Ben Nevarez

Yes, you can use 3 GB in this server by using the /3GB switch on the Windows
boot.ini file. By default Windows uses 2GB and SQL Server can use the other 2
GB on your configuracion. By using the /3GB switch you can allow SQL Server
to use 3 GB but leaving only 1 GB to the operating system.

Hope this helps,

Ben Nevarez
Senior Database Administrator
AIG SunAmerica

Show quote

"Piotr Lipski" wrote:

> Hi.
>
> Is there any way of increasing memory available for SQL Server 2005? The
> maximum I can set from SSMS is 2GB. There is 4GB server designed
> exclusively for SQL databases so I would like to set the memory limit to
> 3GB (or even more).
>
> SQL Server Standard, 32bit.
>
> --
> PL
>