3G ram for SQL server: switch

Showing posts with label switch. Show all posts

Thursday, February 16, 2012

4GB Ram /3GB and the memory slider in Ent Manager

If you use the /3GB switch should the memory slider in SQL Enterprise
Manager display up to 3GB or do you set manually and just assume it's
working?
2000 Advanced server and SQL 2000 Enterprise Edition.
Thanks
PaulPaul,
The maximum value of the slider should show a value of 3-something . (in my
environments it's 3455).
I would suggest not setting a fixed size, always let SQL use as much as
possible.
JP
"Paul Cahill" wrote:
> If you use the /3GB switch should the memory slider in SQL Enterprise
> Manager display up to 3GB or do you set manually and just assume it's
> working?
> 2000 Advanced server and SQL 2000 Enterprise Edition.
> Thanks
> Paul
>
>|||Thanks JP.
Have you got 4GB Ram and if so are you just using /3GB and not PAE or AWE.
I have exactly 4GB ram. If I use PAE the slider in enterprise manager shows
4GB max. With /3GB I only see 2GB.
I don't want to have the overhead of /PAE and it should not be necessary. Is
there any way to see if /3GB is working (from an NT or SQL)?
Paul
"JP de Jong" <JP de Jong@.discussions.microsoft.com> wrote in message
news:1447D55D-C78C-41E8-87EB-FDF4C0E082D8@.microsoft.com...
> Paul,
> The maximum value of the slider should show a value of 3-something . (in
> my
> environments it's 3455).
> I would suggest not setting a fixed size, always let SQL use as much as
> possible.
> JP
> "Paul Cahill" wrote:
>> If you use the /3GB switch should the memory slider in SQL Enterprise
>> Manager display up to 3GB or do you set manually and just assume it's
>> working?
>> 2000 Advanced server and SQL 2000 Enterprise Edition.
>> Thanks
>> Paul
>>|||Paul
Just checked it for you.
We have 4GB RAM in server (Windows 2003Server). In BoOT.INI we have "/3GB
/PAE". (so we do have PAE enabled).
In properties of system (my computer) it says. Physical Address Extensions
enabled. Not sure how to check if /3GB is enabled. You're absolutelt right
that /PAE only is effective when you have more than 4 GB.
/3GB only enables applications to use more virtual memory. I'm not quite
sure if you can find that back in the gui of SQL.
JP
"Paul Cahill" wrote:
> Thanks JP.
> Have you got 4GB Ram and if so are you just using /3GB and not PAE or AWE.
> I have exactly 4GB ram. If I use PAE the slider in enterprise manager shows
> 4GB max. With /3GB I only see 2GB.
> I don't want to have the overhead of /PAE and it should not be necessary. Is
> there any way to see if /3GB is working (from an NT or SQL)?
> Paul
>
> "JP de Jong" <JP de Jong@.discussions.microsoft.com> wrote in message
> news:1447D55D-C78C-41E8-87EB-FDF4C0E082D8@.microsoft.com...
> > Paul,
> >
> > The maximum value of the slider should show a value of 3-something . (in
> > my
> > environments it's 3455).
> >
> > I would suggest not setting a fixed size, always let SQL use as much as
> > possible.
> >
> > JP
> >
> > "Paul Cahill" wrote:
> >
> >> If you use the /3GB switch should the memory slider in SQL Enterprise
> >> Manager display up to 3GB or do you set manually and just assume it's
> >> working?
> >> 2000 Advanced server and SQL 2000 Enterprise Edition.
> >>
> >> Thanks
> >> Paul
> >>
> >>
> >>
>
>|||Thanks JP.
Any idea why you have /PAE? I thought there's got to be an overhead for
address translation.
You don't feel like trying something for me......
Paul
"JP de Jong" <JPdeJong@.discussions.microsoft.com> wrote in message
news:45DC15E7-3C0D-4DD0-ACEE-732E9A8504E0@.microsoft.com...
> Paul
> Just checked it for you.
> We have 4GB RAM in server (Windows 2003Server). In BoOT.INI we have "/3GB
> /PAE". (so we do have PAE enabled).
> In properties of system (my computer) it says. Physical Address Extensions
> enabled. Not sure how to check if /3GB is enabled. You're absolutelt right
> that /PAE only is effective when you have more than 4 GB.
> /3GB only enables applications to use more virtual memory. I'm not quite
> sure if you can find that back in the gui of SQL.
> JP
> "Paul Cahill" wrote:
>> Thanks JP.
>> Have you got 4GB Ram and if so are you just using /3GB and not PAE or
>> AWE.
>> I have exactly 4GB ram. If I use PAE the slider in enterprise manager
>> shows
>> 4GB max. With /3GB I only see 2GB.
>> I don't want to have the overhead of /PAE and it should not be necessary.
>> Is
>> there any way to see if /3GB is working (from an NT or SQL)?
>> Paul
>>
>> "JP de Jong" <JP de Jong@.discussions.microsoft.com> wrote in message
>> news:1447D55D-C78C-41E8-87EB-FDF4C0E082D8@.microsoft.com...
>> > Paul,
>> >
>> > The maximum value of the slider should show a value of 3-something .
>> > (in
>> > my
>> > environments it's 3455).
>> >
>> > I would suggest not setting a fixed size, always let SQL use as much as
>> > possible.
>> >
>> > JP
>> >
>> > "Paul Cahill" wrote:
>> >
>> >> If you use the /3GB switch should the memory slider in SQL Enterprise
>> >> Manager display up to 3GB or do you set manually and just assume it's
>> >> working?
>> >> 2000 Advanced server and SQL 2000 Enterprise Edition.
>> >>
>> >> Thanks
>> >> Paul
>> >>
>> >>
>> >>
>>

Thursday, February 9, 2012

3gig or 4?

I assume there would be advantages going from 3 to 4gig... anyone have
any experiences in this?|||Using AWE on a 4GB box just doesn't make much sense.
PAE (/3GB) will use 3 GB for SQL Server, so in a 4 GB box, AWE uses a fair
amount of resources (including memory) to manage the extended memory,
thereby negating most of the expected performance gain.
My experience is that you have to approach 5 GB + before AWE really shows
any gains.
Of course, it could be hardware related and YMMV.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now

> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||You have no need to use AWE, there are many disadvantages to using AWE as
well.
To determine if the 3GB switch will allow SQL Server to use more memory can
you tell us what the LEAST amount of free memory you see on the system?
What is that MAX amount of memory you see the SQL Server process consume?
On a side note you might not need to add the additional RAM is your buffer
cache hit ratio is already at 99%+
Paul
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now

> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||Well we are actually doing a benchmark session tomorrow.
First we are going to run with 3gig of ram, and benchmark our app/db
performance.
Then, we will restart the SQL server with an additional gig of ram (now
4 gig) and compare.
FYI It's a 20gig database. CPU for the server looks adequate from what
I can see (dual xeon). The SQL server only runs SQL 2005, and it is
exclusive to our app.

>From a benchmark we did a month or so ago, I thought the memory usage
seemed ok.
The disks seemed to be a possible bottle neck - and there seemed to be
a fair bit of paging although how much is normal paging I'm not 100%
sure.
I'm hoping that the extra ram might help reduce disk usage/paging.
Oh I should also mention that we are runing raid 10, have the mdf on
d:, ldf file on e: and tempdb on c:\
David
Paul Widner wrote:[vbcol=seagreen]
> You have no need to use AWE, there are many disadvantages to using AWE as
> well.
> To determine if the 3GB switch will allow SQL Server to use more memory ca
n
> you tell us what the LEAST amount of free memory you see on the system?
> What is that MAX amount of memory you see the SQL Server process consume?
> On a side note you might not need to add the additional RAM is your buffer
> cache hit ratio is already at 99%+
> Paul
> <davconts@.gmail.com> wrote in message
> news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...|||I think that you will find no change or perhaps even a decreased performance
for AWE.
/AWE sets aside 1 GB for the OS AND AWE memory management extensions, and
adds a lot of processing overhead.
With /3GB, the OS still gets 1 GB, but you don't have the AWE overhead.
AWE Net change: Memory about the same, available CPU cycles reduced.
Depending upon the database, number of users, etc., I usually try to have
enough memory so that the majority of active tables are at all times in
cache. Main thing to watch for is memory page I/O. A lot of activity
indicates a need for more memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155170138.095989.131980@.m73g2000cwd.googlegroups.com...
> Well we are actually doing a benchmark session tomorrow.
> First we are going to run with 3gig of ram, and benchmark our app/db
> performance.
> Then, we will restart the SQL server with an additional gig of ram (now
> 4 gig) and compare.
> FYI It's a 20gig database. CPU for the server looks adequate from what
> I can see (dual xeon). The SQL server only runs SQL 2005, and it is
> exclusive to our app.
>
> seemed ok.
> The disks seemed to be a possible bottle neck - and there seemed to be
> a fair bit of paging although how much is normal paging I'm not 100%
> sure.
> I'm hoping that the extra ram might help reduce disk usage/paging.
> Oh I should also mention that we are runing raid 10, have the mdf on
> d:, ldf file on e: and tempdb on c:\
> David
>
> Paul Widner wrote:
>

3gig or 4?

Hey all,
Ok I have a client that currently have 3gig of memory in their SQL
Server (SQL2005).
They are using the /3gb switch in their boot.ini so in theory SQL
server should use greater than 2 gig.
Ok from my understanding, if they put in an extra 1 gig of ram to make
the server now have 4 gig, would this mean that SQL Server would use 3
gig, and the OS 1gig?
So are their any advantages from going from 3gig to 4gig? (would it
help paging for example)
Look forward to your comments
Thanks!Hi,
Read this article..
http://www.sql-server-performance.com/awe_memory.asp
Thanks
Hari
SQL Server MVP
<davconts@.gmail.com> wrote in message
news:1155079279.501553.287040@.i42g2000cwa.googlegroups.com...
> Hey all,
> Ok I have a client that currently have 3gig of memory in their SQL
> Server (SQL2005).
> They are using the /3gb switch in their boot.ini so in theory SQL
> server should use greater than 2 gig.
> Ok from my understanding, if they put in an extra 1 gig of ram to make
> the server now have 4 gig, would this mean that SQL Server would use 3
> gig, and the OS 1gig?
> So are their any advantages from going from 3gig to 4gig? (would it
> help paging for example)
> Look forward to your comments
> Thanks!
>|||That article is not exactly accurate or clear in places. For instance, it
states, "AWE memory technology is used only for the RAM that exceeds the base
4GB of RAM". That is not correct. You can enable AWE with less than 4GB of
RAM.
Linchi
"Hari Prasad" wrote:
> Hi,
> Read this article..
> http://www.sql-server-performance.com/awe_memory.asp
> Thanks
> Hari
> SQL Server MVP
> <davconts@.gmail.com> wrote in message
> news:1155079279.501553.287040@.i42g2000cwa.googlegroups.com...
> > Hey all,
> >
> > Ok I have a client that currently have 3gig of memory in their SQL
> > Server (SQL2005).
> >
> > They are using the /3gb switch in their boot.ini so in theory SQL
> > server should use greater than 2 gig.
> >
> > Ok from my understanding, if they put in an extra 1 gig of ram to make
> > the server now have 4 gig, would this mean that SQL Server would use 3
> > gig, and the OS 1gig?
> >
> > So are their any advantages from going from 3gig to 4gig? (would it
> > help paging for example)
> >
> > Look forward to your comments
> >
> > Thanks!
> >
>
>|||Thanks for the replies.
I read the article but it doesn't really answer my question on whether
it is worth going from 3Gig to 4gig... will SQL server be able to use
that extra gig placed in the machine or will the OS take hold of the
1gig?
Sounds like using AWE will take all the memory (besides 128 meg) unless
a max memory setting is specified in SQL.. so in theory this could
force it to use say 3.5gig of memory.
But the article also suggests not using AWE for a 4gig machine.. so bit
confused now :)
I assume there would be advantages going from 3 to 4gig... anyone have
any experiences in this?|||Using AWE on a 4GB box just doesn't make much sense.
PAE (/3GB) will use 3 GB for SQL Server, so in a 4 GB box, AWE uses a fair
amount of resources (including memory) to manage the extended memory,
thereby negating most of the expected performance gain.
My experience is that you have to approach 5 GB + before AWE really shows
any gains.
Of course, it could be hardware related and YMMV.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now :)
> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||You have no need to use AWE, there are many disadvantages to using AWE as
well.
To determine if the 3GB switch will allow SQL Server to use more memory can
you tell us what the LEAST amount of free memory you see on the system?
What is that MAX amount of memory you see the SQL Server process consume?
On a side note you might not need to add the additional RAM is your buffer
cache hit ratio is already at 99%+
Paul
<davconts@.gmail.com> wrote in message
news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> Thanks for the replies.
> I read the article but it doesn't really answer my question on whether
> it is worth going from 3Gig to 4gig... will SQL server be able to use
> that extra gig placed in the machine or will the OS take hold of the
> 1gig?
> Sounds like using AWE will take all the memory (besides 128 meg) unless
> a max memory setting is specified in SQL.. so in theory this could
> force it to use say 3.5gig of memory.
> But the article also suggests not using AWE for a 4gig machine.. so bit
> confused now :)
> I assume there would be advantages going from 3 to 4gig... anyone have
> any experiences in this?
>|||Well we are actually doing a benchmark session tomorrow.
First we are going to run with 3gig of ram, and benchmark our app/db
performance.
Then, we will restart the SQL server with an additional gig of ram (now
4 gig) and compare.
FYI It's a 20gig database. CPU for the server looks adequate from what
I can see (dual xeon). The SQL server only runs SQL 2005, and it is
exclusive to our app.
>From a benchmark we did a month or so ago, I thought the memory usage
seemed ok.
The disks seemed to be a possible bottle neck - and there seemed to be
a fair bit of paging although how much is normal paging I'm not 100%
sure.
I'm hoping that the extra ram might help reduce disk usage/paging.
Oh I should also mention that we are runing raid 10, have the mdf on
d:, ldf file on e: and tempdb on c:\
David
Paul Widner wrote:
> You have no need to use AWE, there are many disadvantages to using AWE as
> well.
> To determine if the 3GB switch will allow SQL Server to use more memory can
> you tell us what the LEAST amount of free memory you see on the system?
> What is that MAX amount of memory you see the SQL Server process consume?
> On a side note you might not need to add the additional RAM is your buffer
> cache hit ratio is already at 99%+
> Paul
> <davconts@.gmail.com> wrote in message
> news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
> > Thanks for the replies.
> >
> > I read the article but it doesn't really answer my question on whether
> > it is worth going from 3Gig to 4gig... will SQL server be able to use
> > that extra gig placed in the machine or will the OS take hold of the
> > 1gig?
> >
> > Sounds like using AWE will take all the memory (besides 128 meg) unless
> > a max memory setting is specified in SQL.. so in theory this could
> > force it to use say 3.5gig of memory.
> > But the article also suggests not using AWE for a 4gig machine.. so bit
> > confused now :)
> >
> > I assume there would be advantages going from 3 to 4gig... anyone have
> > any experiences in this?
> >|||I think that you will find no change or perhaps even a decreased performance
for AWE.
/AWE sets aside 1 GB for the OS AND AWE memory management extensions, and
adds a lot of processing overhead.
With /3GB, the OS still gets 1 GB, but you don't have the AWE overhead.
AWE Net change: Memory about the same, available CPU cycles reduced.
Depending upon the database, number of users, etc., I usually try to have
enough memory so that the majority of active tables are at all times in
cache. Main thing to watch for is memory page I/O. A lot of activity
indicates a need for more memory.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<davconts@.gmail.com> wrote in message
news:1155170138.095989.131980@.m73g2000cwd.googlegroups.com...
> Well we are actually doing a benchmark session tomorrow.
> First we are going to run with 3gig of ram, and benchmark our app/db
> performance.
> Then, we will restart the SQL server with an additional gig of ram (now
> 4 gig) and compare.
> FYI It's a 20gig database. CPU for the server looks adequate from what
> I can see (dual xeon). The SQL server only runs SQL 2005, and it is
> exclusive to our app.
>>From a benchmark we did a month or so ago, I thought the memory usage
> seemed ok.
> The disks seemed to be a possible bottle neck - and there seemed to be
> a fair bit of paging although how much is normal paging I'm not 100%
> sure.
> I'm hoping that the extra ram might help reduce disk usage/paging.
> Oh I should also mention that we are runing raid 10, have the mdf on
> d:, ldf file on e: and tempdb on c:\
> David
>
> Paul Widner wrote:
>> You have no need to use AWE, there are many disadvantages to using AWE as
>> well.
>> To determine if the 3GB switch will allow SQL Server to use more memory
>> can
>> you tell us what the LEAST amount of free memory you see on the system?
>> What is that MAX amount of memory you see the SQL Server process consume?
>> On a side note you might not need to add the additional RAM is your
>> buffer
>> cache hit ratio is already at 99%+
>> Paul
>> <davconts@.gmail.com> wrote in message
>> news:1155086938.963563.37190@.m79g2000cwm.googlegroups.com...
>> > Thanks for the replies.
>> >
>> > I read the article but it doesn't really answer my question on whether
>> > it is worth going from 3Gig to 4gig... will SQL server be able to use
>> > that extra gig placed in the machine or will the OS take hold of the
>> > 1gig?
>> >
>> > Sounds like using AWE will take all the memory (besides 128 meg) unless
>> > a max memory setting is specified in SQL.. so in theory this could
>> > force it to use say 3.5gig of memory.
>> > But the article also suggests not using AWE for a 4gig machine.. so bit
>> > confused now :)
>> >
>> > I assume there would be advantages going from 3 to 4gig... anyone have
>> > any experiences in this?
>> >
>

3GB Switch question

I am using the following:
Windows 2003 Enterprise
SQL 2000 Std SP3
6GB Ram
4 CPU's with HT turned on (3.2)
I will be running multiple instances of DB.
What should the entry in boot.ini be to best utilise the resources.
Thanks.Leon
http://support.microsoft.com/kb/274750
"Leon" <Lion@.hotmail.com> wrote in message
news:%23$czIrCTHHA.920@.TK2MSFTNGP05.phx.gbl...
>I am using the following:
> Windows 2003 Enterprise
> SQL 2000 Std SP3
> 6GB Ram
> 4 CPU's with HT turned on (3.2)
> I will be running multiple instances of DB.
> What should the entry in boot.ini be to best utilise the resources.
>
> Thanks.
>|||Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OL1Fg0CTHHA.2212@.TK2MSFTNGP02.phx.gbl...
> Leon
> http://support.microsoft.com/kb/274750
>
> "Leon" <Lion@.hotmail.com> wrote in message
> news:%23$czIrCTHHA.920@.TK2MSFTNGP05.phx.gbl...
>>I am using the following:
>> Windows 2003 Enterprise
>> SQL 2000 Std SP3
>> 6GB Ram
>> 4 CPU's with HT turned on (3.2)
>> I will be running multiple instances of DB.
>> What should the entry in boot.ini be to best utilise the resources.
>>
>> Thanks.
>|||To add on URI; if it is 64 bit system and SQL Server standard edition 64 bit
; then there is no need to change the memory addreesss space. This is
because 64 bit
can address more memory with out changing the BOOT.INI.
Thanks
Hari
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OL1Fg0CTHHA.2212@.TK2MSFTNGP02.phx.gbl...
> Leon
> http://support.microsoft.com/kb/274750
>
> "Leon" <Lion@.hotmail.com> wrote in message
> news:%23$czIrCTHHA.920@.TK2MSFTNGP05.phx.gbl...
>>I am using the following:
>> Windows 2003 Enterprise
>> SQL 2000 Std SP3
>> 6GB Ram
>> 4 CPU's with HT turned on (3.2)
>> I will be running multiple instances of DB.
>> What should the entry in boot.ini be to best utilise the resources.
>>
>> Thanks.
>|||Guys,
Is this the same for SQL 2005 Enterprise on 2003 Standard R2 server? Do I
need to make any changes to boot.ini? The document in KB is for 2000 SQL and
I can not find anything for 2005 SQL. Please help.
"Hari Prasad" wrote:
> To add on URI; if it is 64 bit system and SQL Server standard edition 64 bit
> ; then there is no need to change the memory addreesss space. This is
> because 64 bit
> can address more memory with out changing the BOOT.INI.
> Thanks
> Hari
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OL1Fg0CTHHA.2212@.TK2MSFTNGP02.phx.gbl...
> > Leon
> > http://support.microsoft.com/kb/274750
> >
> >
> >
> > "Leon" <Lion@.hotmail.com> wrote in message
> > news:%23$czIrCTHHA.920@.TK2MSFTNGP05.phx.gbl...
> >>I am using the following:
> >>
> >> Windows 2003 Enterprise
> >> SQL 2000 Std SP3
> >> 6GB Ram
> >> 4 CPU's with HT turned on (3.2)
> >>
> >> I will be running multiple instances of DB.
> >>
> >> What should the entry in boot.ini be to best utilise the resources.
> >>
> >>
> >>
> >> Thanks.
> >>
> >
> >
>
>|||If it is 32 bit and you want the app (in this case SQL Server) to use 3GB
instead of 2GB of directly addressable memory you need to set the /3GB
switch. But I don't believe Windows2003 Std edition uses more than 2 GB to
begin with. I could be wrong on that part though. But the bottom line is the
OS needs to support the memory before SQL Server can. And starting with
SQL2005 Std Edition and up can use all the memory that the OS can access
given the correct configuration.
--
Andrew J. Kelly SQL MVP
"George" <George@.discussions.microsoft.com> wrote in message
news:F8306B35-4D7A-498E-AE05-7C58442A233B@.microsoft.com...
> Guys,
> Is this the same for SQL 2005 Enterprise on 2003 Standard R2 server? Do I
> need to make any changes to boot.ini? The document in KB is for 2000 SQL
> and
> I can not find anything for 2005 SQL. Please help.
> "Hari Prasad" wrote:
>> To add on URI; if it is 64 bit system and SQL Server standard edition 64
>> bit
>> ; then there is no need to change the memory addreesss space. This is
>> because 64 bit
>> can address more memory with out changing the BOOT.INI.
>> Thanks
>> Hari
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OL1Fg0CTHHA.2212@.TK2MSFTNGP02.phx.gbl...
>> > Leon
>> > http://support.microsoft.com/kb/274750
>> >
>> >
>> >
>> > "Leon" <Lion@.hotmail.com> wrote in message
>> > news:%23$czIrCTHHA.920@.TK2MSFTNGP05.phx.gbl...
>> >>I am using the following:
>> >>
>> >> Windows 2003 Enterprise
>> >> SQL 2000 Std SP3
>> >> 6GB Ram
>> >> 4 CPU's with HT turned on (3.2)
>> >>
>> >> I will be running multiple instances of DB.
>> >>
>> >> What should the entry in boot.ini be to best utilise the resources.
>> >>
>> >>
>> >>
>> >> Thanks.
>> >>
>> >
>> >
>>|||Thank you. Anyone knows how to set this correctly on 2003 Standard Server?
"Andrew J. Kelly" wrote:
> If it is 32 bit and you want the app (in this case SQL Server) to use 3GB
> instead of 2GB of directly addressable memory you need to set the /3GB
> switch. But I don't believe Windows2003 Std edition uses more than 2 GB to
> begin with. I could be wrong on that part though. But the bottom line is the
> OS needs to support the memory before SQL Server can. And starting with
> SQL2005 Std Edition and up can use all the memory that the OS can access
> given the correct configuration.
> --
> Andrew J. Kelly SQL MVP
> "George" <George@.discussions.microsoft.com> wrote in message
> news:F8306B35-4D7A-498E-AE05-7C58442A233B@.microsoft.com...
> > Guys,
> >
> > Is this the same for SQL 2005 Enterprise on 2003 Standard R2 server? Do I
> > need to make any changes to boot.ini? The document in KB is for 2000 SQL
> > and
> > I can not find anything for 2005 SQL. Please help.
> >
> > "Hari Prasad" wrote:
> >
> >> To add on URI; if it is 64 bit system and SQL Server standard edition 64
> >> bit
> >> ; then there is no need to change the memory addreesss space. This is
> >> because 64 bit
> >> can address more memory with out changing the BOOT.INI.
> >>
> >> Thanks
> >> Hari
> >>
> >>
> >> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> >> news:OL1Fg0CTHHA.2212@.TK2MSFTNGP02.phx.gbl...
> >> > Leon
> >> > http://support.microsoft.com/kb/274750
> >> >
> >> >
> >> >
> >> > "Leon" <Lion@.hotmail.com> wrote in message
> >> > news:%23$czIrCTHHA.920@.TK2MSFTNGP05.phx.gbl...
> >> >>I am using the following:
> >> >>
> >> >> Windows 2003 Enterprise
> >> >> SQL 2000 Std SP3
> >> >> 6GB Ram
> >> >> 4 CPU's with HT turned on (3.2)
> >> >>
> >> >> I will be running multiple instances of DB.
> >> >>
> >> >> What should the entry in boot.ini be to best utilise the resources.
> >> >>
> >> >>
> >> >>
> >> >> Thanks.
> >> >>
> >> >
> >> >
> >>
> >>
> >>
>
>|||You might want to have a look at these. The concepts are the same.
http://sqljunkies.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk
Memory
http://www.sql-server-performance.com/awe_memory.asp Using AWE Memory
http://www.support.microsoft.com/?id=321363 SQL Server 7 & 2000 memory
usage
http://www.support.microsoft.com/?id=274750 Memory config
http://www.support.microsoft.com/?id=283037 Large Memory Support Is
Available in Windows 2000 (AWE)
http://www.support.microsoft.com/?id=811891 Can not use more than 2GB of
memory
--
Andrew J. Kelly SQL MVP
"George" <George@.discussions.microsoft.com> wrote in message
news:602610CF-D97C-4E87-81F0-1B9E6BC615C3@.microsoft.com...
> Thank you. Anyone knows how to set this correctly on 2003 Standard Server?
> "Andrew J. Kelly" wrote:
>> If it is 32 bit and you want the app (in this case SQL Server) to use 3GB
>> instead of 2GB of directly addressable memory you need to set the /3GB
>> switch. But I don't believe Windows2003 Std edition uses more than 2 GB
>> to
>> begin with. I could be wrong on that part though. But the bottom line is
>> the
>> OS needs to support the memory before SQL Server can. And starting with
>> SQL2005 Std Edition and up can use all the memory that the OS can access
>> given the correct configuration.
>> --
>> Andrew J. Kelly SQL MVP
>> "George" <George@.discussions.microsoft.com> wrote in message
>> news:F8306B35-4D7A-498E-AE05-7C58442A233B@.microsoft.com...
>> > Guys,
>> >
>> > Is this the same for SQL 2005 Enterprise on 2003 Standard R2 server? Do
>> > I
>> > need to make any changes to boot.ini? The document in KB is for 2000
>> > SQL
>> > and
>> > I can not find anything for 2005 SQL. Please help.
>> >
>> > "Hari Prasad" wrote:
>> >
>> >> To add on URI; if it is 64 bit system and SQL Server standard edition
>> >> 64
>> >> bit
>> >> ; then there is no need to change the memory addreesss space. This is
>> >> because 64 bit
>> >> can address more memory with out changing the BOOT.INI.
>> >>
>> >> Thanks
>> >> Hari
>> >>
>> >>
>> >> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> >> news:OL1Fg0CTHHA.2212@.TK2MSFTNGP02.phx.gbl...
>> >> > Leon
>> >> > http://support.microsoft.com/kb/274750
>> >> >
>> >> >
>> >> >
>> >> > "Leon" <Lion@.hotmail.com> wrote in message
>> >> > news:%23$czIrCTHHA.920@.TK2MSFTNGP05.phx.gbl...
>> >> >>I am using the following:
>> >> >>
>> >> >> Windows 2003 Enterprise
>> >> >> SQL 2000 Std SP3
>> >> >> 6GB Ram
>> >> >> 4 CPU's with HT turned on (3.2)
>> >> >>
>> >> >> I will be running multiple instances of DB.
>> >> >>
>> >> >> What should the entry in boot.ini be to best utilise the resources.
>> >> >>
>> >> >>
>> >> >>
>> >> >> Thanks.
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>

3GB switch in boot ini

I have a server which has 4gig of memory. I have
modified the boot.ini file to include the /3GB switch. I
have looked at the process work set for SQLServer and it
still appears to be using only 2gig's of memory. This
server does have WIN2K Advance server and is also SQL
Server 200 Enterprise.
How can I find out if SQL Server is using the 3 gig I
have available?
thanksPerformance Monitor Counter:
SQL Server: Memory Manager:Total Server Memory
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
> I have a server which has 4gig of memory. I have
> modified the boot.ini file to include the /3GB switch. I
> have looked at the process work set for SQLServer and it
> still appears to be using only 2gig's of memory. This
> server does have WIN2K Advance server and is also SQL
> Server 200 Enterprise.
> How can I find out if SQL Server is using the 3 gig I
> have available?
> thanks|||"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
> I have a server which has 4gig of memory. I have
> modified the boot.ini file to include the /3GB switch. I
> have looked at the process work set for SQLServer and it
> still appears to be using only 2gig's of memory. This
> server does have WIN2K Advance server and is also SQL
> Server 200 Enterprise.
> How can I find out if SQL Server is using the 3 gig I
> have available?
Performance monitor (Perfmon.exe) would be one way...
Steve|||That is what I used and it still only shows 1700544. The
Process:Work Set counter for SQLServr shows 1.7gig also.
I have SQL set to dynamic allocation. Seems the the
switch made no difference.
thanks
>--Original Message--
>Performance Monitor Counter:
>SQL Server: Memory Manager:Total Server Memory
>
>--
>Kevin Connell, MCDBA
>----
>The views expressed here are my own
>and not of my employer.
>----
>"Kevin" <anonymous@.discussions.microsoft.com> wrote in
message
>news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
>> I have a server which has 4gig of memory. I have
>> modified the boot.ini file to include the /3GB
switch. I
>> have looked at the process work set for SQLServer and
it
>> still appears to be using only 2gig's of memory. This
>> server does have WIN2K Advance server and is also SQL
>> Server 200 Enterprise.
>> How can I find out if SQL Server is using the 3 gig I
>> have available?
>> thanks
>
>.
>|||Something in the back of mind is reminding me that you actually need more
than 4GB of RAM to take advantage of >2GB memory, and that that docs are
either wrong or misleading, but I may be thinking about PAE/AWE. Try to
enable /PAE and AWE and see where that leads you.
--
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
<anonymous@.discussions.microsoft.com> wrote in message
news:00c601c39fe7$b63eb310$a601280a@.phx.gbl...
> That is what I used and it still only shows 1700544. The
> Process:Work Set counter for SQLServr shows 1.7gig also.
> I have SQL set to dynamic allocation. Seems the the
> switch made no difference.
> thanks
> >--Original Message--
> >Performance Monitor Counter:
> >
> >SQL Server: Memory Manager:Total Server Memory
> >
> >
> >--
> >Kevin Connell, MCDBA
> >----
> >The views expressed here are my own
> >and not of my employer.
> >----
> >"Kevin" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
> >> I have a server which has 4gig of memory. I have
> >> modified the boot.ini file to include the /3GB
> switch. I
> >> have looked at the process work set for SQLServer and
> it
> >> still appears to be using only 2gig's of memory. This
> >> server does have WIN2K Advance server and is also SQL
> >> Server 200 Enterprise.
> >>
> >> How can I find out if SQL Server is using the 3 gig I
> >> have available?
> >>
> >> thanks
> >
> >
> >.
> >

3gb switch and AWE

in configuring AWE whether i need use both 3GB in boot.ini and AWE Enabling option in SQL ServerFor 32 bit OS and 32 bit SQL Server, the answer is: Yes. You want to use both. The /3GB switch allows SQL Server to use a portion of the OS 2GB allotment and does not have the same overhead as AWE memory. Also the AWE memory can only be used for data, whereas the /3GB memory can be used for server object caching.|||thanks

Thursday, February 16, 2012

4GB Ram /3GB and the memory slider in Ent Manager

4GB Ram /3GB and the memory slider in Ent Manager

4GB Ram /3GB and the memory slider in Ent Manager

Thursday, February 9, 2012

3gig or 4?

3gig or 4?

3GB Switch question

3GB Switch question

3GB Switch question

3GB switch in boot ini

3gb switch and AWE

3G ram for SQL server

Blog Archive

About Me