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
Showing posts with label ent. Show all posts
Showing posts with label ent. Show all posts
Tuesday, March 20, 2012
/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/defaul...;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/defaul...;274750&sd=tech
> "Ada" <Ada@.discussions.microsoft.com> wrote in message
> news:390E7800-A4CD-4F18-AC52-C9FF26C5DF7C@.microsoft.com...
>
>|||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...[vbcol=seagreen]
> Uri,
> It's 3.7GB.
> To be able to utilize existing physical memory.
> Ada
> SQL Server DBA
>
> "Uri Dimant" wrote:
>|||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...
>
>|||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...[vbcol=seagreen]
> Uri,
> I read the article and the topic on BOL. They don't have the answer.
> Ada
> SQL Server DBA
>
> "Uri Dimant" wrote:
>|||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...
>
>|||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...[vbcol=seagreen]
> 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:
>
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/defaul...;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/defaul...;274750&sd=tech
> "Ada" <Ada@.discussions.microsoft.com> wrote in message
> news:390E7800-A4CD-4F18-AC52-C9FF26C5DF7C@.microsoft.com...
>
>|||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...[vbcol=seagreen]
> Uri,
> It's 3.7GB.
> To be able to utilize existing physical memory.
> Ada
> SQL Server DBA
>
> "Uri Dimant" wrote:
>|||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...
>
>|||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...[vbcol=seagreen]
> Uri,
> I read the article and the topic on BOL. They don't have the answer.
> Ada
> SQL Server DBA
>
> "Uri Dimant" wrote:
>|||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...
>
>|||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...[vbcol=seagreen]
> 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:
>
/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 DBA
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...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...274750&sd=tech
> "Ada" <Ada@.discussions.microsoft.com> wrote in message
> news:390E7800-A4CD-4F18-AC52-C9FF26C5DF7C@.microsoft.com...
>
>
|||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...[vbcol=seagreen]
> Uri,
> It's 3.7GB.
> To be able to utilize existing physical memory.
> Ada
> SQL Server DBA
>
> "Uri Dimant" wrote:
|||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...
>
>
|||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...[vbcol=seagreen]
> Uri,
> I read the article and the topic on BOL. They don't have the answer.
> Ada
> SQL Server DBA
>
> "Uri Dimant" wrote:
|||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...
>
>
|||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...[vbcol=seagreen]
> 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:
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
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...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...274750&sd=tech
> "Ada" <Ada@.discussions.microsoft.com> wrote in message
> news:390E7800-A4CD-4F18-AC52-C9FF26C5DF7C@.microsoft.com...
>
>
|||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...[vbcol=seagreen]
> Uri,
> It's 3.7GB.
> To be able to utilize existing physical memory.
> Ada
> SQL Server DBA
>
> "Uri Dimant" wrote:
|||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...
>
>
|||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...[vbcol=seagreen]
> Uri,
> I read the article and the topic on BOL. They don't have the answer.
> Ada
> SQL Server DBA
>
> "Uri Dimant" wrote:
|||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...
>
>
|||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...[vbcol=seagreen]
> 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:
Monday, March 19, 2012
/3gb
I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone adviseIt depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linea
r
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. S
ee
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>
>|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...[vbcol=seagreen]
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
>|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
>
>
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone adviseIt depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linea
r
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. S
ee
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>
>|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...[vbcol=seagreen]
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
>|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
>
>
/3gb
I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone adviseIt depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >
> > What are my options to best use the RAM?
> > 1. /3GB in Boot.ini and AWE not enabled
> > 2. /3GB in Boot.ini and AWE enabled.
> >
> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> > need
> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> > MEMORY datatype is INT and can only take 2GB
> >
> > Can anyone advise
>
>|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
>> It depends on how much memory you need for the operating system plus
>> other
>> stuff you may have on the server. 1GB is great but with a simple server
>> with just SQL Server and SQL Agent running 512 will be fine. Using only
>> /3GB is simple and works you could combine them and allow for 3GB of
>> linear
>> memory and 500MB for AWE.
>> The configure value for memory is in MB so an int is plenty big enough.
>> See
>> BOL for details.
>> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
>> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
>> >
>> > What are my options to best use the RAM?
>> > 1. /3GB in Boot.ini and AWE not enabled
>> > 2. /3GB in Boot.ini and AWE enabled.
>> >
>> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
>> > need
>> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
>> > SERVER
>> > MEMORY datatype is INT and can only take 2GB
>> >
>> > Can anyone advise
>>|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> > Thks Danny.
> >
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> >
> > Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> > tell it to) use 3GB of RAM?
> >
> > "Danny" wrote:
> >
> >> It depends on how much memory you need for the operating system plus
> >> other
> >> stuff you may have on the server. 1GB is great but with a simple server
> >> with just SQL Server and SQL Agent running 512 will be fine. Using only
> >> /3GB is simple and works you could combine them and allow for 3GB of
> >> linear
> >> memory and 500MB for AWE.
> >>
> >> The configure value for memory is in MB so an int is plenty big enough.
> >> See
> >> BOL for details.
> >>
> >> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> >> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >> >
> >> > What are my options to best use the RAM?
> >> > 1. /3GB in Boot.ini and AWE not enabled
> >> > 2. /3GB in Boot.ini and AWE enabled.
> >> >
> >> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> >> > need
> >> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
> >> > SERVER
> >> > MEMORY datatype is INT and can only take 2GB
> >> >
> >> > Can anyone advise
> >>
> >>
> >>
>
>
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone adviseIt depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >
> > What are my options to best use the RAM?
> > 1. /3GB in Boot.ini and AWE not enabled
> > 2. /3GB in Boot.ini and AWE enabled.
> >
> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> > need
> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> > MEMORY datatype is INT and can only take 2GB
> >
> > Can anyone advise
>
>|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
>> It depends on how much memory you need for the operating system plus
>> other
>> stuff you may have on the server. 1GB is great but with a simple server
>> with just SQL Server and SQL Agent running 512 will be fine. Using only
>> /3GB is simple and works you could combine them and allow for 3GB of
>> linear
>> memory and 500MB for AWE.
>> The configure value for memory is in MB so an int is plenty big enough.
>> See
>> BOL for details.
>> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
>> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
>> >
>> > What are my options to best use the RAM?
>> > 1. /3GB in Boot.ini and AWE not enabled
>> > 2. /3GB in Boot.ini and AWE enabled.
>> >
>> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
>> > need
>> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
>> > SERVER
>> > MEMORY datatype is INT and can only take 2GB
>> >
>> > Can anyone advise
>>|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> > Thks Danny.
> >
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> >
> > Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> > tell it to) use 3GB of RAM?
> >
> > "Danny" wrote:
> >
> >> It depends on how much memory you need for the operating system plus
> >> other
> >> stuff you may have on the server. 1GB is great but with a simple server
> >> with just SQL Server and SQL Agent running 512 will be fine. Using only
> >> /3GB is simple and works you could combine them and allow for 3GB of
> >> linear
> >> memory and 500MB for AWE.
> >>
> >> The configure value for memory is in MB so an int is plenty big enough.
> >> See
> >> BOL for details.
> >>
> >> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> >> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >> >
> >> > What are my options to best use the RAM?
> >> > 1. /3GB in Boot.ini and AWE not enabled
> >> > 2. /3GB in Boot.ini and AWE enabled.
> >> >
> >> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> >> > need
> >> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
> >> > SERVER
> >> > MEMORY datatype is INT and can only take 2GB
> >> >
> >> > Can anyone advise
> >>
> >>
> >>
>
>
/3gb
I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone advise
It depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise
|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>
>
|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...[vbcol=seagreen]
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
>
>
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone advise
It depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise
|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>
>
|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...[vbcol=seagreen]
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)