memory question day..

SQL Server Enterprise edition 2000 sp4+.2187, 32 bit
Windows Server 2003 R2, Enterprise, 64bit
40gb ram in the system, no other apps.
I'm looking for the optimal settings for this box with regards to Min/Max,
AWE, Boot.ini file etc.
Sp_configure shows that whoever built this box set AWE =1, min and max -
33000000 (32.6gb)
The properties of the server, memory tab show the memory fixed at the full
40gb
perfmon shows the SQL memory Manager:total server memory counter at
39973432kb (38gb).
Not sure which GUI to trust here.
Thanks!
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available./pae in boot.ini?
Set min memory a gig or so less than max.
watch pages/sec in perfmon occassionally to ensure not paging.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:%23lIXDm4XIHA.6140@.TK2MSFTNGP02.phx.gbl...
> SQL Server Enterprise edition 2000 sp4+.2187, 32 bit
> Windows Server 2003 R2, Enterprise, 64bit
> 40gb ram in the system, no other apps.
> I'm looking for the optimal settings for this box with regards to Min/Max,
> AWE, Boot.ini file etc.
> Sp_configure shows that whoever built this box set AWE =1, min and max -
> 33000000 (32.6gb)
> The properties of the server, memory tab show the memory fixed at the full
> 40gb
> perfmon shows the SQL memory Manager:total server memory counter at
> 39973432kb (38gb).
> Not sure which GUI to trust here.
> Thanks!
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
>|||In this situation...would you set max at the total ram on the box? Seems
like you should specifically allow some room for the O/S...but I'm just not
all that familiar with 64 bit architecture
there are two lines in the boot.ini (alternate startup options)...one with
/pae, one without. Anyway to tell which was used? The one without is the
default
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:13pkgobj171ir65@.corp.supernews.com...
> /pae in boot.ini?
> Set min memory a gig or so less than max.
> watch pages/sec in perfmon occassionally to ensure not paging.
>
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:%23lIXDm4XIHA.6140@.TK2MSFTNGP02.phx.gbl...
>> SQL Server Enterprise edition 2000 sp4+.2187, 32 bit
>> Windows Server 2003 R2, Enterprise, 64bit
>> 40gb ram in the system, no other apps.
>> I'm looking for the optimal settings for this box with regards to
>> Min/Max, AWE, Boot.ini file etc.
>> Sp_configure shows that whoever built this box set AWE =1, min and max -
>> 33000000 (32.6gb)
>> The properties of the server, memory tab show the memory fixed at the
>> full 40gb
>> perfmon shows the SQL memory Manager:total server memory counter at
>> 39973432kb (38gb).
>> Not sure which GUI to trust here.
>> Thanks!
>> --
>> Kevin3NF
>> SQL Server dude
>> You want fries with that?
>> http://kevin3nf.blogspot.com/
>> I only check the newsgroups during work hours, M-F.
>> Hit my blog and the contact links if necessary...I may be available.
>>
>>
>|||Note that the numbers for max/min server memory are in MB, not in KB.
> Sp_configure shows that whoever built this box set AWE =1, min and max -
> 33000000 (32.6gb)
So you are setting max/min server memory to ~33,000GB, which basically
leaves it up to the SQL Server instance to grab as much memory as it needs
minus some for the OS. On a box like this, in most cases, I'd just leave 4GB
for the OS and set the rest for max/min server memory.
Linchi
"Kevin3NF" wrote:
> SQL Server Enterprise edition 2000 sp4+.2187, 32 bit
> Windows Server 2003 R2, Enterprise, 64bit
> 40gb ram in the system, no other apps.
> I'm looking for the optimal settings for this box with regards to Min/Max,
> AWE, Boot.ini file etc.
> Sp_configure shows that whoever built this box set AWE =1, min and max -
> 33000000 (32.6gb)
> The properties of the server, memory tab show the memory fixed at the full
> 40gb
> perfmon shows the SQL memory Manager:total server memory counter at
> 39973432kb (38gb).
> Not sure which GUI to trust here.
> Thanks!
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
>
>|||:) I didn't build this box, and just noticed that someone set it to
32TB...too funny.
Nice catch, thanks. We had just set it to 36gb for min/max, with AWE
enabled.
Is /PAE necessary for 32 bit SQL on 64 bit Windows? I'm thinking yes.
Thanks,
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:F867817C-8307-4257-911B-ED5B9D51A5EC@.microsoft.com...
> Note that the numbers for max/min server memory are in MB, not in KB.
>> Sp_configure shows that whoever built this box set AWE =1, min and max -
>> 33000000 (32.6gb)
> So you are setting max/min server memory to ~33,000GB, which basically
> leaves it up to the SQL Server instance to grab as much memory as it needs
> minus some for the OS. On a box like this, in most cases, I'd just leave
> 4GB
> for the OS and set the rest for max/min server memory.
> Linchi
> "Kevin3NF" wrote:
>> SQL Server Enterprise edition 2000 sp4+.2187, 32 bit
>> Windows Server 2003 R2, Enterprise, 64bit
>> 40gb ram in the system, no other apps.
>> I'm looking for the optimal settings for this box with regards to
>> Min/Max,
>> AWE, Boot.ini file etc.
>> Sp_configure shows that whoever built this box set AWE =1, min and max -
>> 33000000 (32.6gb)
>> The properties of the server, memory tab show the memory fixed at the
>> full
>> 40gb
>> perfmon shows the SQL memory Manager:total server memory counter at
>> 39973432kb (38gb).
>> Not sure which GUI to trust here.
>> Thanks!
>> --
>> Kevin3NF
>> SQL Server dude
>> You want fries with that?
>> http://kevin3nf.blogspot.com/
>> I only check the newsgroups during work hours, M-F.
>> Hit my blog and the contact links if necessary...I may be available.
>>
>>|||> Is /PAE necessary for 32 bit SQL on 64 bit Windows? I'm thinking yes.
No need for /PAE.
Linchi
"Kevin3NF" wrote:
> :) I didn't build this box, and just noticed that someone set it to
> 32TB...too funny.
> Nice catch, thanks. We had just set it to 36gb for min/max, with AWE
> enabled.
> Is /PAE necessary for 32 bit SQL on 64 bit Windows? I'm thinking yes.
> Thanks,
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:F867817C-8307-4257-911B-ED5B9D51A5EC@.microsoft.com...
> > Note that the numbers for max/min server memory are in MB, not in KB.
> >
> >> Sp_configure shows that whoever built this box set AWE =1, min and max -
> >> 33000000 (32.6gb)
> >
> > So you are setting max/min server memory to ~33,000GB, which basically
> > leaves it up to the SQL Server instance to grab as much memory as it needs
> > minus some for the OS. On a box like this, in most cases, I'd just leave
> > 4GB
> > for the OS and set the rest for max/min server memory.
> >
> > Linchi
> >
> > "Kevin3NF" wrote:
> >
> >> SQL Server Enterprise edition 2000 sp4+.2187, 32 bit
> >> Windows Server 2003 R2, Enterprise, 64bit
> >> 40gb ram in the system, no other apps.
> >>
> >> I'm looking for the optimal settings for this box with regards to
> >> Min/Max,
> >> AWE, Boot.ini file etc.
> >>
> >> Sp_configure shows that whoever built this box set AWE =1, min and max -
> >> 33000000 (32.6gb)
> >>
> >> The properties of the server, memory tab show the memory fixed at the
> >> full
> >> 40gb
> >>
> >> perfmon shows the SQL memory Manager:total server memory counter at
> >> 39973432kb (38gb).
> >>
> >> Not sure which GUI to trust here.
> >>
> >> Thanks!
> >>
> >> --
> >>
> >> Kevin3NF
> >> SQL Server dude
> >>
> >> You want fries with that?
> >> http://kevin3nf.blogspot.com/
> >>
> >> I only check the newsgroups during work hours, M-F.
> >> Hit my blog and the contact links if necessary...I may be available.
> >>
> >>
> >>
> >>
> >>
>
>|||/PAE is an operating system flag, that changes the amount of directly
addressable memory for a 32-bit OS, for all applications. It has nothing
specific to do with SQL Server. So if Windows is 64-bit, there is no need
for /PAE.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:eFkqEi5XIHA.5980@.TK2MSFTNGP04.phx.gbl...
> :) I didn't build this box, and just noticed that someone set it to
> 32TB...too funny.
> Nice catch, thanks. We had just set it to 36gb for min/max, with AWE
> enabled.
> Is /PAE necessary for 32 bit SQL on 64 bit Windows? I'm thinking yes.
> Thanks,
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:F867817C-8307-4257-911B-ED5B9D51A5EC@.microsoft.com...
>> Note that the numbers for max/min server memory are in MB, not in KB.
>> Sp_configure shows that whoever built this box set AWE =1, min and max -
>> 33000000 (32.6gb)
>> So you are setting max/min server memory to ~33,000GB, which basically
>> leaves it up to the SQL Server instance to grab as much memory as it
>> needs
>> minus some for the OS. On a box like this, in most cases, I'd just leave
>> 4GB
>> for the OS and set the rest for max/min server memory.
>> Linchi
>> "Kevin3NF" wrote:
>> SQL Server Enterprise edition 2000 sp4+.2187, 32 bit
>> Windows Server 2003 R2, Enterprise, 64bit
>> 40gb ram in the system, no other apps.
>> I'm looking for the optimal settings for this box with regards to
>> Min/Max,
>> AWE, Boot.ini file etc.
>> Sp_configure shows that whoever built this box set AWE =1, min and max -
>> 33000000 (32.6gb)
>> The properties of the server, memory tab show the memory fixed at the
>> full
>> 40gb
>> perfmon shows the SQL memory Manager:total server memory counter at
>> 39973432kb (38gb).
>> Not sure which GUI to trust here.
>> Thanks!
>> --
>> Kevin3NF
>> SQL Server dude
>> You want fries with that?
>> http://kevin3nf.blogspot.com/
>> I only check the newsgroups during work hours, M-F.
>> Hit my blog and the contact links if necessary...I may be available.
>>
>>
>