/3GB with 3.7GB RAM?

Hi All,
SQL Server 2000 Ent.Ed. is running on Windows 2000 Adv. Server.
It's a dedicated sql server; no clustering and no replication.
I would like to increase max memory of sql server process by leaving 1GB for
kernal/OS.
If I use /3GB and set "max server memory" to 2.7GB, will OS be able to have
1GB or 3.7GB - 3GB = 7MB ?
Thanks,
Ada
SQL Server DBAAda
How much memory does the server have?
Why would you think that changing a memory from a default will be
beneficial?
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech
"Ada" <Ada@.discussions.microsoft.com> wrote in message
news:390E7800-A4CD-4F18-AC52-C9FF26C5DF7C@.microsoft.com...
> Hi All,
> SQL Server 2000 Ent.Ed. is running on Windows 2000 Adv. Server.
> It's a dedicated sql server; no clustering and no replication.
> I would like to increase max memory of sql server process by leaving 1GB
> for
> kernal/OS.
> If I use /3GB and set "max server memory" to 2.7GB, will OS be able to
> have
> 1GB or 3.7GB - 3GB = 7MB ?
> Thanks,
> Ada
> SQL Server DBA|||Uri,
It's 3.7GB.
To be able to utilize existing physical memory.
Ada
SQL Server DBA
"Uri Dimant" wrote:
> Ada
> How much memory does the server have?
> Why would you think that changing a memory from a default will be
> beneficial?
> http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech
> "Ada" <Ada@.discussions.microsoft.com> wrote in message
> news:390E7800-A4CD-4F18-AC52-C9FF26C5DF7C@.microsoft.com...
> >
> > Hi All,
> >
> > SQL Server 2000 Ent.Ed. is running on Windows 2000 Adv. Server.
> > It's a dedicated sql server; no clustering and no replication.
> > I would like to increase max memory of sql server process by leaving 1GB
> > for
> > kernal/OS.
> >
> > If I use /3GB and set "max server memory" to 2.7GB, will OS be able to
> > have
> > 1GB or 3.7GB - 3GB = 7MB ?
> >
> > Thanks,
> >
> > Ada
> > SQL Server DBA
>
>|||Ada
Please read a topic in BOL about set up max memory in SQL Server.
"Ada" <Ada@.discussions.microsoft.com> wrote in message
news:923E5CDC-1E94-40EA-AC1E-A918FD68A670@.microsoft.com...
> Uri,
> It's 3.7GB.
> To be able to utilize existing physical memory.
> Ada
> SQL Server DBA
>
> "Uri Dimant" wrote:
>> Ada
>> How much memory does the server have?
>> Why would you think that changing a memory from a default will be
>> beneficial?
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech
>> "Ada" <Ada@.discussions.microsoft.com> wrote in message
>> news:390E7800-A4CD-4F18-AC52-C9FF26C5DF7C@.microsoft.com...
>> >
>> > Hi All,
>> >
>> > SQL Server 2000 Ent.Ed. is running on Windows 2000 Adv. Server.
>> > It's a dedicated sql server; no clustering and no replication.
>> > I would like to increase max memory of sql server process by leaving
>> > 1GB
>> > for
>> > kernal/OS.
>> >
>> > If I use /3GB and set "max server memory" to 2.7GB, will OS be able to
>> > have
>> > 1GB or 3.7GB - 3GB = 7MB ?
>> >
>> > Thanks,
>> >
>> > Ada
>> > SQL Server DBA
>>|||Uri,
I read the article and the topic on BOL. They don't have the answer.
Ada
SQL Server DBA
"Uri Dimant" wrote:
> Ada
> Please read a topic in BOL about set up max memory in SQL Server.
>
> "Ada" <Ada@.discussions.microsoft.com> wrote in message
> news:923E5CDC-1E94-40EA-AC1E-A918FD68A670@.microsoft.com...
> >
> > Uri,
> >
> > It's 3.7GB.
> > To be able to utilize existing physical memory.
> >
> > Ada
> >
> > SQL Server DBA
> >
> >
> > "Uri Dimant" wrote:
> >
> >> Ada
> >> How much memory does the server have?
> >>
> >> Why would you think that changing a memory from a default will be
> >> beneficial?
> >>
> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech
> >>
> >> "Ada" <Ada@.discussions.microsoft.com> wrote in message
> >> news:390E7800-A4CD-4F18-AC52-C9FF26C5DF7C@.microsoft.com...
> >> >
> >> > Hi All,
> >> >
> >> > SQL Server 2000 Ent.Ed. is running on Windows 2000 Adv. Server.
> >> > It's a dedicated sql server; no clustering and no replication.
> >> > I would like to increase max memory of sql server process by leaving
> >> > 1GB
> >> > for
> >> > kernal/OS.
> >> >
> >> > If I use /3GB and set "max server memory" to 2.7GB, will OS be able to
> >> > have
> >> > 1GB or 3.7GB - 3GB = 7MB ?
> >> >
> >> > Thanks,
> >> >
> >> > Ada
> >> > SQL Server DBA
> >>
> >>
> >>
>
>|||Ada
Have you read the article that I posted ?
Here is another one
http://support.microsoft.com/kb/291988/
"Ada" <Ada@.discussions.microsoft.com> wrote in message
news:6960BEF0-1F2F-4009-9CB6-80CF6EF60DED@.microsoft.com...
> Uri,
> I read the article and the topic on BOL. They don't have the answer.
> Ada
> SQL Server DBA
>
> "Uri Dimant" wrote:
>> Ada
>> Please read a topic in BOL about set up max memory in SQL Server.
>>
>> "Ada" <Ada@.discussions.microsoft.com> wrote in message
>> news:923E5CDC-1E94-40EA-AC1E-A918FD68A670@.microsoft.com...
>> >
>> > Uri,
>> >
>> > It's 3.7GB.
>> > To be able to utilize existing physical memory.
>> >
>> > Ada
>> >
>> > SQL Server DBA
>> >
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Ada
>> >> How much memory does the server have?
>> >>
>> >> Why would you think that changing a memory from a default will be
>> >> beneficial?
>> >>
>> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech
>> >>
>> >> "Ada" <Ada@.discussions.microsoft.com> wrote in message
>> >> news:390E7800-A4CD-4F18-AC52-C9FF26C5DF7C@.microsoft.com...
>> >> >
>> >> > Hi All,
>> >> >
>> >> > SQL Server 2000 Ent.Ed. is running on Windows 2000 Adv. Server.
>> >> > It's a dedicated sql server; no clustering and no replication.
>> >> > I would like to increase max memory of sql server process by leaving
>> >> > 1GB
>> >> > for
>> >> > kernal/OS.
>> >> >
>> >> > If I use /3GB and set "max server memory" to 2.7GB, will OS be able
>> >> > to
>> >> > have
>> >> > 1GB or 3.7GB - 3GB = 7MB ?
>> >> >
>> >> > Thanks,
>> >> >
>> >> > Ada
>> >> > SQL Server DBA
>> >>
>> >>
>> >>
>>|||Uri,
I read those articles after they published. I just wanted what my
understanding to be confirmed. Otherwise I need to make the change and run
sy.mon. t make sure. It's not easy to do it on a prod box.
If I use /3GB and set "max server memory" to 2.7GB, will OS be able to have
1GB or 3.7GB - 3GB = 700MB ?
My understanding is that it will be limited to 700MB, and 0.3GB on user-mode
will be wasted. All I need is a Yes or No.
Thanks,
Ada
SQL Server DBA
"Uri Dimant" wrote:
> Ada
> Have you read the article that I posted ?
> Here is another one
> http://support.microsoft.com/kb/291988/
>
> "Ada" <Ada@.discussions.microsoft.com> wrote in message
> news:6960BEF0-1F2F-4009-9CB6-80CF6EF60DED@.microsoft.com...
> >
> > Uri,
> >
> > I read the article and the topic on BOL. They don't have the answer.
> >
> > Ada
> > SQL Server DBA
> >
> >
> > "Uri Dimant" wrote:
> >
> >> Ada
> >>
> >> Please read a topic in BOL about set up max memory in SQL Server.
> >>
> >>
> >>
> >> "Ada" <Ada@.discussions.microsoft.com> wrote in message
> >> news:923E5CDC-1E94-40EA-AC1E-A918FD68A670@.microsoft.com...
> >> >
> >> > Uri,
> >> >
> >> > It's 3.7GB.
> >> > To be able to utilize existing physical memory.
> >> >
> >> > Ada
> >> >
> >> > SQL Server DBA
> >> >
> >> >
> >> > "Uri Dimant" wrote:
> >> >
> >> >> Ada
> >> >> How much memory does the server have?
> >> >>
> >> >> Why would you think that changing a memory from a default will be
> >> >> beneficial?
> >> >>
> >> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech
> >> >>
> >> >> "Ada" <Ada@.discussions.microsoft.com> wrote in message
> >> >> news:390E7800-A4CD-4F18-AC52-C9FF26C5DF7C@.microsoft.com...
> >> >> >
> >> >> > Hi All,
> >> >> >
> >> >> > SQL Server 2000 Ent.Ed. is running on Windows 2000 Adv. Server.
> >> >> > It's a dedicated sql server; no clustering and no replication.
> >> >> > I would like to increase max memory of sql server process by leaving
> >> >> > 1GB
> >> >> > for
> >> >> > kernal/OS.
> >> >> >
> >> >> > If I use /3GB and set "max server memory" to 2.7GB, will OS be able
> >> >> > to
> >> >> > have
> >> >> > 1GB or 3.7GB - 3GB = 7MB ?
> >> >> >
> >> >> > Thanks,
> >> >> >
> >> >> > Ada
> >> >> > SQL Server DBA
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||It's obvious how NT partitions memory when you have <=2GB or >=4GB but what
about 3.75GB
If the /3GB switch is used with 3.75GB does this mean:
NT gets 0.75GB and applications get 3.0GB
or
NT gets 1.00GB and applications get 2.75GB
Paul
I guess
"Ada" <Ada@.discussions.microsoft.com> wrote in message
news:BD42BFD4-1ABF-4375-9A91-00EEFE544C6A@.microsoft.com...
> Uri,
> I read those articles after they published. I just wanted what my
> understanding to be confirmed. Otherwise I need to make the change and run
> sy.mon. t make sure. It's not easy to do it on a prod box.
> If I use /3GB and set "max server memory" to 2.7GB, will OS be able to
> have
> 1GB or 3.7GB - 3GB = 700MB ?
> My understanding is that it will be limited to 700MB, and 0.3GB on
> user-mode
> will be wasted. All I need is a Yes or No.
> Thanks,
> Ada
> SQL Server DBA
>
> "Uri Dimant" wrote:
>> Ada
>> Have you read the article that I posted ?
>> Here is another one
>> http://support.microsoft.com/kb/291988/
>>
>> "Ada" <Ada@.discussions.microsoft.com> wrote in message
>> news:6960BEF0-1F2F-4009-9CB6-80CF6EF60DED@.microsoft.com...
>> >
>> > Uri,
>> >
>> > I read the article and the topic on BOL. They don't have the answer.
>> >
>> > Ada
>> > SQL Server DBA
>> >
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Ada
>> >>
>> >> Please read a topic in BOL about set up max memory in SQL Server.
>> >>
>> >>
>> >>
>> >> "Ada" <Ada@.discussions.microsoft.com> wrote in message
>> >> news:923E5CDC-1E94-40EA-AC1E-A918FD68A670@.microsoft.com...
>> >> >
>> >> > Uri,
>> >> >
>> >> > It's 3.7GB.
>> >> > To be able to utilize existing physical memory.
>> >> >
>> >> > Ada
>> >> >
>> >> > SQL Server DBA
>> >> >
>> >> >
>> >> > "Uri Dimant" wrote:
>> >> >
>> >> >> Ada
>> >> >> How much memory does the server have?
>> >> >>
>> >> >> Why would you think that changing a memory from a default will be
>> >> >> beneficial?
>> >> >>
>> >> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech
>> >> >>
>> >> >> "Ada" <Ada@.discussions.microsoft.com> wrote in message
>> >> >> news:390E7800-A4CD-4F18-AC52-C9FF26C5DF7C@.microsoft.com...
>> >> >> >
>> >> >> > Hi All,
>> >> >> >
>> >> >> > SQL Server 2000 Ent.Ed. is running on Windows 2000 Adv. Server.
>> >> >> > It's a dedicated sql server; no clustering and no replication.
>> >> >> > I would like to increase max memory of sql server process by
>> >> >> > leaving
>> >> >> > 1GB
>> >> >> > for
>> >> >> > kernal/OS.
>> >> >> >
>> >> >> > If I use /3GB and set "max server memory" to 2.7GB, will OS be
>> >> >> > able
>> >> >> > to
>> >> >> > have
>> >> >> > 1GB or 3.7GB - 3GB = 7MB ?
>> >> >> >
>> >> >> > Thanks,
>> >> >> >
>> >> >> > Ada
>> >> >> > SQL Server DBA
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>sql