what is your OS version?
"Simon" <Simon@discussions.microsoft.com> wrote in message
news86C6528-C966-42D1-9D8A-BBD32A7F8527@microsoft.com...
>I have Enterprise edition though. But it still maxes out at 1.7G.
>
> Do I have to have the /3GB switch in the boot.ini ?
>
> "Keith Kratochvil" wrote:
>
>> From the "Maximum Capacity Specifications" within Books Online:
>> SQL 2k Standard Edition only supports 2GB of RAM.
>> SQL2k EE supports up to 64GB of RAM under the appropriate Operating
>> System.
>>
>> --
>> Keith Kratochvil
>>
>>
>> "Simon" <Simon@discussions.microsoft.com> wrote in message
>> news:FFAA80F9-D096-4045-8013-E32F0F6EC6B7@microsoft.com...
>> >I have a dual processor server with 4G of memory. However SQL 2000 is
>> >only
>> > using 1.7G. I have looked at sp_configure to get SQL to use more memory
>> > but I
>> > don`t seem to get better than 1.7G. Why is this ? What is the easiest
>> > way
>> > to
>> > increase the memory used by SQL ?
>> >
>> > Thanks
>> >
>> > Si
>>
>>
>>