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

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

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
>
>
>

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
>>
>>
>>

What OS are you running?

Open Books Online and choose "Go" from the menu.
Enter this into the url line:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\architec.chm::/8_ar_sa_6b3k.htm

The page that is displayed will be: Using AWE Memory on Windows 2000

You should add /3GB or /PAE to the boot ini. You will also need to
configure SQL Server to use the additional memory via sp_configure and the
'awe enabled' option.

--
Keith Kratochvil


"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
>>
>>
>>

I am using Windwos 2003.

Is it worth enabling AWE for a 4G server though ? I thought it need to be
more than 4G to make it worthwhile.

I have already changed the setting in sp_configure.

"Keith Kratochvil" wrote:

> What OS are you running?
>
> Open Books Online and choose "Go" from the menu.
> Enter this into the url line:
> mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\architec.chm::/8_ar_sa_6b3k.htm
>
> The page that is displayed will be: Using AWE Memory on Windows 2000
>
> You should add /3GB or /PAE to the boot ini. You will also need to
> configure SQL Server to use the additional memory via sp_configure and the
> 'awe enabled' option.
>
> --
> Keith Kratochvil
>
>
> "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
> >>
> >>
> >>
>
>
>

OK - so assuming its standard edition, it supports 4GB.
Check this link out for exactly how to do what you want -
http://support.microsoft.com/kb/274750/
But, I tend to agree with you, for the extra 1GB - I'm not so sure i'd go
messing around with the OS.

Immy

"Simon" <Simon@discussions.microsoft.com> wrote in message
news:4F31F562-88F7-441C-8C9D-702849E5A141@microsoft.com...
>I am using Windwos 2003.
>
> Is it worth enabling AWE for a 4G server though ? I thought it need to be
> more than 4G to make it worthwhile.
>
> I have already changed the setting in sp_configure.
>
> "Keith Kratochvil" wrote:
>
>> What OS are you running?
>>
>> Open Books Online and choose "Go" from the menu.
>> Enter this into the url line:
>> mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\architec.chm::/8_ar_sa_6b3k.htm
>>
>> The page that is displayed will be: Using AWE Memory on Windows 2000
>>
>> You should add /3GB or /PAE to the boot ini. You will also need to
>> configure SQL Server to use the additional memory via sp_configure and
>> the
>> 'awe enabled' option.
>>
>> --
>> Keith Kratochvil
>>
>>
>> "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
>> >>
>> >>
>> >>
>>
>>
>>

Memory below 4 GB is not usable for AWE. Use only the /3GB switch. And
extend the Server Max Memory configuration setting.

See:

Memory -AWE, Not usable < 4GB
http://download.microsoft.com/downlo...dv64BitEnv.doc


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Immy" <therealasianbabe@hotmail.com> wrote in message
news:uNjKKAM3GHA.4484@TK2MSFTNGP02.phx.gbl...
> OK - so assuming its standard edition, it supports 4GB.
> Check this link out for exactly how to do what you want -
> http://support.microsoft.com/kb/274750/
> But, I tend to agree with you, for the extra 1GB - I'm not so sure i'd go
> messing around with the OS.
>
> Immy
>
> "Simon" <Simon@discussions.microsoft.com> wrote in message
> news:4F31F562-88F7-441C-8C9D-702849E5A141@microsoft.com...
>>I am using Windwos 2003.
>>
>> Is it worth enabling AWE for a 4G server though ? I thought it need to be
>> more than 4G to make it worthwhile.
>>
>> I have already changed the setting in sp_configure.
>>
>> "Keith Kratochvil" wrote:
>>
>>> What OS are you running?
>>>
>>> Open Books Online and choose "Go" from the menu.
>>> Enter this into the url line:
>>> mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\architec.chm::/8_ar_sa_6b3k.htm
>>>
>>> The page that is displayed will be: Using AWE Memory on Windows 2000
>>>
>>> You should add /3GB or /PAE to the boot ini. You will also need to
>>> configure SQL Server to use the additional memory via sp_configure and
>>> the
>>> 'awe enabled' option.
>>>
>>> --
>>> Keith Kratochvil
>>>
>>>
>>> "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
>>> >>
>>> >>
>>> >>
>>>
>>>
>>>
>
>