SQL SQLExpress: 4gb

Showing posts with label 4gb. Show all posts

Tuesday, March 20, 2012

/3GB Switch

Hi All

Server 2003 standard edition, MSsql 2005 standard edition

As I understand it server 2003 standard only supports 4gb. Does this mean I can only use up to 4gb as the maximum memory for server 2005?

If that is the case I would like to use the 3GB switch, and leave the other gig for other apps. If I set the 3GB switch in boot.ini do I then also have to enable AWE (which I can't seem to do) or can I forget about AWE altogether?

Many thanks

Martin

Dear Martin.

If your server has 4GB or less of RAM, the "awe enabled" option should always be left to the default value of 0, which means that AWE memory is not being used. The /3GB switch is used to tell SQL Server to take advantage of 3GB out of the base 4GB of RAM that Windows supports natively. If you don't specify this option, then SQL Server will only take advantage of 2GB of the first 4GB of RAM in the server, essentially wasting 1GB of RAM.

If you'll set only /3GB switch and AWE will leave 0 it will be great.

Kind Regards,

Martin Bacik

|||

Hi Martin,

That answers my question perfectly. Many thanks

Martin (2)

|||

Hi again,

I set the 3gb switch and rebooted but I can't increase the maximum mermory spinform in server manager. I can't go above 2gb.

Any advice greatly appreciated

Best Regards

Martin

|||

Here's how to change in through the system stored proc:

Code Snippet

--To display all options

EXEC sp_configure 'show advanced options',1

RECONFIGURE

--To change the max server memory.

EXEC sp_configure 'max server memory (MB)', 3072

RECONFIGURE

--To switch off the display of all the options

EXEC sp_configure 'show advanced options',0

RECONFIGURE

Probably want to bounce the SQL service after that.

HTH

Ray

/3GB Switch

Hi All

Server 2003 standard edition, MSsql 2005 standard edition

As I understand it server 2003 standard only supports 4gb. Does this mean I can only use up to 4gb as the maximum memory for server 2005?

Many thanks

Martin

Dear Martin.

If you'll set only /3GB switch and AWE will leave 0 it will be great.

Kind Regards,

Martin Bacik

|||

Hi Martin,

That answers my question perfectly. Many thanks

Martin (2)

|||

Hi again,

I set the 3gb switch and rebooted but I can't increase the maximum mermory spinform in server manager. I can't go above 2gb.

Any advice greatly appreciated

Best Regards

Martin

|||

Here's how to change in through the system stored proc:

Code Snippet

--To display all options

EXEC sp_configure 'show advanced options',1

RECONFIGURE

--To change the max server memory.

EXEC sp_configure 'max server memory (MB)', 3072

RECONFIGURE

--To switch off the display of all the options

EXEC sp_configure 'show advanced options',0

RECONFIGURE

Probably want to bounce the SQL service after that.

HTH

Ray

/3Gb option set, but SQL Server use only 1.7Gb....

Hi,
I have setup the /3Gb option in the boot.ini file because my server has 4Gb
of RAM.
But SQL Server still use only 1.7Gb.
on another server, there is no problems, the same parameters and SQL Server
use more then 2Gb of memory!!!
there is anything missing ?
what can I check?
thanks.
Jerome.Which OS version and edition and SQL Server edition are you using?
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:uaW1M4HaFHA.2212@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have setup the /3Gb option in the boot.ini file because my server has
> 4Gb of RAM.
> But SQL Server still use only 1.7Gb.
> on another server, there is no problems, the same parameters and SQL
> Server use more then 2Gb of memory!!!
> there is anything missing ?
> what can I check?
> thanks.
> Jerome.
>|||Jéjé wrote:
> Hi,
> I have setup the /3Gb option in the boot.ini file because my server
> has 4Gb of RAM.
> But SQL Server still use only 1.7Gb.
> on another server, there is no problems, the same parameters and SQL
> Server use more then 2Gb of memory!!!
> there is anything missing ?
> what can I check?
> thanks.
> Jerome.
Are you running SQL 2000 Service Pack 4? If so, there's a known issue
with AWE that is going to be addressed with a hotfix in the next week or
two.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:uaW1M4HaFHA.2212@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have setup the /3Gb option in the boot.ini file because my server has
> 4Gb of RAM.
> But SQL Server still use only 1.7Gb.
> on another server, there is no problems, the same parameters and SQL
> Server use more then 2Gb of memory!!!
> there is anything missing ?
> what can I check?
Use /pae in boot.ini and enable awe in SQL Server, then your SQL should be
able to consume ca. 3.75 GB of RAM (W2K AS + SQL EE SP3)
Regards
Wojtek|||Yes, SP4 installed
on a Win 2003 Enterprise edition server
AWE is NOT enable on the server.
For a 4Gb system what is the best option?
/3Gb
/3Gb + AWE
/PAE
/PAE + AWE
/3Gb /PAE
/3Gb /PAE + AWE
?
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eYe9KLIaFHA.616@.TK2MSFTNGP12.phx.gbl...
> Jéjé wrote:
>> Hi,
>> I have setup the /3Gb option in the boot.ini file because my server
>> has 4Gb of RAM.
>> But SQL Server still use only 1.7Gb.
>> on another server, there is no problems, the same parameters and SQL
>> Server use more then 2Gb of memory!!!
>> there is anything missing ?
>> what can I check?
>> thanks.
>> Jerome.
> Are you running SQL 2000 Service Pack 4? If so, there's a known issue with
> AWE that is going to be addressed with a hotfix in the next week or two.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:uJz3PVKaFHA.612@.TK2MSFTNGP12.phx.gbl...
> Yes, SP4 installed
> on a Win 2003 Enterprise edition server
> AWE is NOT enable on the server.
> For a 4Gb system what is the best option?
> /3Gb
> /3Gb + AWE
> /PAE
> /PAE + AWE
> /3Gb /PAE
> /3Gb /PAE + AWE
> ?
/3Gb /PAE + AWE
But AFAIK not with SP4... SP4 has some issue with /pae and AWE.
Regards
Wojtek|||You still need SQL Enterprise Edition to use more than 2GB. It sounds like
you are using Standard Edition of SQL Server. What does @.@.Version show?
--
Andrew J. Kelly SQL MVP
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:uJz3PVKaFHA.612@.TK2MSFTNGP12.phx.gbl...
> Yes, SP4 installed
> on a Win 2003 Enterprise edition server
> AWE is NOT enable on the server.
> For a 4Gb system what is the best option?
> /3Gb
> /3Gb + AWE
> /PAE
> /PAE + AWE
> /3Gb /PAE
> /3Gb /PAE + AWE
> ?
>
> "David Gugick" <david.gugick-nospam@.quest.com> wrote in message
> news:eYe9KLIaFHA.616@.TK2MSFTNGP12.phx.gbl...
>> Jéjé wrote:
>> Hi,
>> I have setup the /3Gb option in the boot.ini file because my server
>> has 4Gb of RAM.
>> But SQL Server still use only 1.7Gb.
>> on another server, there is no problems, the same parameters and SQL
>> Server use more then 2Gb of memory!!!
>> there is anything missing ?
>> what can I check?
>> thanks.
>> Jerome.
>> Are you running SQL 2000 Service Pack 4? If so, there's a known issue
>> with AWE that is going to be addressed with a hotfix in the next week or
>> two.
>> --
>> David Gugick
>> Quest Software
>> www.imceda.com
>> www.quest.com
>|||/PAE is only required for > 4 GB. AWE can be enabled before then. And,
/3GB should be enabled all the time up to 16 GB, but on Win2K3, you should
use the USERVA to start scalling back from 3 GB around 12 GB of ram or so.
Again, if you are only using Standard Edition Win2K, /3GB is NOT supported.
Sincerely,
Anthony Thomas
"Wojtek Garwol" <garwol@.usunto.poczta.fm> wrote in message
news:d7qj6e$jsu$1@.nemesis.news.tpi.pl...
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:uaW1M4HaFHA.2212@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have setup the /3Gb option in the boot.ini file because my server has
> 4Gb of RAM.
> But SQL Server still use only 1.7Gb.
> on another server, there is no problems, the same parameters and SQL
> Server use more then 2Gb of memory!!!
> there is anything missing ?
> what can I check?
Use /pae in boot.ini and enable awe in SQL Server, then your SQL should be
able to consume ca. 3.75 GB of RAM (W2K AS + SQL EE SP3)
Regards
Wojtek|||I think its the standard edition of SQL 2000.
I'll check this.
but...
on another environment the memory usage go up to 2.7gb.
its a Win 2003 Ent. server (SP1) + SQL 2000 enterprise (SP4)
4 Gb of memory, 2.7g used by SQL and 512mb of free memory.
there is no upper limit usage for SQL Server.
the /3Gb option is enabled AWE disabled.
why SQL don't use more memory?
any missing option in this case?
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:O8Sh0AQaFHA.3876@.TK2MSFTNGP12.phx.gbl...
> You still need SQL Enterprise Edition to use more than 2GB. It sounds
> like you are using Standard Edition of SQL Server. What does @.@.Version
> show?
> --
> Andrew J. Kelly SQL MVP
>
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:uJz3PVKaFHA.612@.TK2MSFTNGP12.phx.gbl...
>> Yes, SP4 installed
>> on a Win 2003 Enterprise edition server
>> AWE is NOT enable on the server.
>> For a 4Gb system what is the best option?
>> /3Gb
>> /3Gb + AWE
>> /PAE
>> /PAE + AWE
>> /3Gb /PAE
>> /3Gb /PAE + AWE
>> ?
>>
>> "David Gugick" <david.gugick-nospam@.quest.com> wrote in message
>> news:eYe9KLIaFHA.616@.TK2MSFTNGP12.phx.gbl...
>> Jéjé wrote:
>> Hi,
>> I have setup the /3Gb option in the boot.ini file because my server
>> has 4Gb of RAM.
>> But SQL Server still use only 1.7Gb.
>> on another server, there is no problems, the same parameters and SQL
>> Server use more then 2Gb of memory!!!
>> there is anything missing ?
>> what can I check?
>> thanks.
>> Jerome.
>> Are you running SQL 2000 Service Pack 4? If so, there's a known issue
>> with AWE that is going to be addressed with a hotfix in the next week or
>> two.
>> --
>> David Gugick
>> Quest Software
>> www.imceda.com
>> www.quest.com
>>
>|||This is a multi-part message in MIME format.
--030301010703050100030701
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
The reason SQL memory allocation is only going up to 2.7G is because a
Win32 process can only address 4G of RAM (without changes to the memory
model, like PAE & AWE). This 4G is split up into 2 components: user
addressable memory & kernel addressable memory. The split is normally
2G/2G but when you specify the /3GB switch in boot.ini this means the OS
will only allocate a maximum of 1G to the kernel for each process. So
this means that when addressing 4G of memory the kernel code will
address 1G and the user code will address 3G of memory (hence the /3GB
switch - it would be more accurate to call it the "/1GB" switch because
that's the bit it's really limiting).
To address more than 4GB of memory you have to either switch to 64-bit
or change the memory management strategy, for example by using PAE &
AWE. But in your case, with 4GB of physical RAM in the box and the /3GB
boot.ini switch enabled, the memory ceiling for SQL Server will be 3GB,
and 2.7GB is getting pretty close. Remember SQL Server will, by
default, release memory when other applications request memory and there
is none left (it tries to maintain a free memory threshold of 10MB by
default) because of the dynamic memory management model SQL has implemented.
HTH
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jéjé wrote:
>I think its the standard edition of SQL 2000.
>I'll check this.
>but...
>on another environment the memory usage go up to 2.7gb.
>its a Win 2003 Ent. server (SP1) + SQL 2000 enterprise (SP4)
>4 Gb of memory, 2.7g used by SQL and 512mb of free memory.
>there is no upper limit usage for SQL Server.
>the /3Gb option is enabled AWE disabled.
>why SQL don't use more memory?
>any missing option in this case?
>"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>news:O8Sh0AQaFHA.3876@.TK2MSFTNGP12.phx.gbl...
>
>>You still need SQL Enterprise Edition to use more than 2GB. It sounds
>>like you are using Standard Edition of SQL Server. What does @.@.Version
>>show?
>>--
>>Andrew J. Kelly SQL MVP
>>
>>"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
>>news:uJz3PVKaFHA.612@.TK2MSFTNGP12.phx.gbl...
>>
>>Yes, SP4 installed
>>on a Win 2003 Enterprise edition server
>>AWE is NOT enable on the server.
>>For a 4Gb system what is the best option?
>>/3Gb
>>/3Gb + AWE
>>/PAE
>>/PAE + AWE
>>/3Gb /PAE
>>/3Gb /PAE + AWE
>>?
>>
>>"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
>>news:eYe9KLIaFHA.616@.TK2MSFTNGP12.phx.gbl...
>>
>>Jéjé wrote:
>>
>>Hi,
>>I have setup the /3Gb option in the boot.ini file because my server
>>has 4Gb of RAM.
>>But SQL Server still use only 1.7Gb.
>>on another server, there is no problems, the same parameters and SQL
>>Server use more then 2Gb of memory!!!
>>there is anything missing ?
>>what can I check?
>>thanks.
>>Jerome.
>>
>>Are you running SQL 2000 Service Pack 4? If so, there's a known issue
>>with AWE that is going to be addressed with a hotfix in the next week or
>>two.
>>--
>>David Gugick
>>Quest Software
>>www.imceda.com
>>www.quest.com
>>
>>
>>
>
>
--030301010703050100030701
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>The reason SQL memory allocation is only going up to 2.7G is
because a Win32 process can only address 4G of RAM (without changes to
the memory model, like PAE & AWE). This 4G is split up into 2
components: user addressable memory & kernel addressable memory.
The split is normally 2G/2G but when you specify the /3GB switch in
boot.ini this means the OS will only allocate a maximum of 1G to the
kernel for each process. So this means that when addressing 4G of
memory the kernel code will address 1G and the user code will address
3G of memory (hence the /3GB switch - it would be more accurate to call
it the "/1GB" switch because that's the bit it's really limiting). 
 
To address more than 4GB of memory you have to either switch to 64-bit
or change the memory management strategy, for example by using PAE
& AWE. But in your case, with 4GB of physical RAM in the box and
the /3GB boot.ini switch enabled, the memory ceiling for SQL Server
will be 3GB, and 2.7GB is getting pretty close. Remember SQL Server
will, by default, release memory when other applications request memory
and there is none left (it tries to maintain a free memory threshold of
10MB by default) because of the dynamic memory management model SQL has
implemented. 
 
HTH 
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Jéjé wrote:
<blockquote cite="miduIfJy7IcFHA.2688@.TK2MSFTNGP14.phx.gbl" type="cite">
<pre wrap="">I think its the standard edition of SQL 2000.
I'll check this.
but...
on another environment the memory usage go up to 2.7gb.
its a Win 2003 Ent. server (SP1) + SQL 2000 enterprise (SP4)
4 Gb of memory, 2.7g used by SQL and 512mb of free memory.
there is no upper limit usage for SQL Server.
the /3Gb option is enabled AWE disabled.
why SQL don't use more memory?
any missing option in this case?
"Andrew J. Kelly" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:sqlmvpnooospam@.shadhawk.com"><sqlmvpnooospam@.shadhawk.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:O8Sh0AQaFHA.3876@.TK2MSFTNGP12.phx.gbl">news:O8Sh0AQaFHA.3876@.TK2MSFTNGP12.phx.gbl</a>...
</pre>
<blockquote type="cite">
<pre wrap="">You still need SQL Enterprise Edition to use more than 2GB. It sounds
like you are using Standard Edition of SQL Server. What does @.@.Version
show?
--
Andrew J. Kelly SQL MVP
"Jéjé" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:willgart_A_@.hotmail_A_.com"><willgart_A_@.hotmail_A_.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:uJz3PVKaFHA.612@.TK2MSFTNGP12.phx.gbl">news:uJz3PVKaFHA.612@.TK2MSFTNGP12.phx.gbl</a>...
</pre>
<blockquote type="cite">
<pre wrap="">Yes, SP4 installed
on a Win 2003 Enterprise edition server
AWE is NOT enable on the server.
For a 4Gb system what is the best option?
/3Gb
/3Gb + AWE
/PAE
/PAE + AWE
/3Gb /PAE
/3Gb /PAE + AWE
?
"David Gugick" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:david.gugick-nospam@.quest.com"><david.gugick-nospam@.quest.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:eYe9KLIaFHA.616@.TK2MSFTNGP12.phx.gbl">news:eYe9KLIaFHA.616@.TK2MSFTNGP12.phx.gbl</a>...
</pre>
<blockquote type="cite">
<pre wrap="">Jéjé wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi,
I have setup the /3Gb option in the boot.ini file because my server
has 4Gb of RAM.
But SQL Server still use only 1.7Gb.
on another server, there is no problems, the same parameters and SQL
Server use more then 2Gb of memory!!!
there is anything missing ?
what can I check?
thanks.
Jerome.
</pre>
</blockquote>
<pre wrap="">Are you running SQL 2000 Service Pack 4? If so, there's a known issue
with AWE that is going to be addressed with a hotfix in the next week or
two.
--
David Gugick
Quest Software
<a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=www.imceda.com</a>">http://www.imceda.com">www.imceda.com</a>
<a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=www.quest.com</a>">http://www.quest.com">www.quest.com</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
</body>
</html>
--030301010703050100030701--|||The other .3GB is used by MemToLeave and does not show in Task manager like
the memory pool does. That is perfectly normal for 4GB of ram with /3GB set
and Enterprise Edition.
--
Andrew J. Kelly SQL MVP
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:uIfJy7IcFHA.2688@.TK2MSFTNGP14.phx.gbl...
>I think its the standard edition of SQL 2000.
> I'll check this.
> but...
> on another environment the memory usage go up to 2.7gb.
> its a Win 2003 Ent. server (SP1) + SQL 2000 enterprise (SP4)
> 4 Gb of memory, 2.7g used by SQL and 512mb of free memory.
> there is no upper limit usage for SQL Server.
> the /3Gb option is enabled AWE disabled.
> why SQL don't use more memory?
> any missing option in this case?
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:O8Sh0AQaFHA.3876@.TK2MSFTNGP12.phx.gbl...
>> You still need SQL Enterprise Edition to use more than 2GB. It sounds
>> like you are using Standard Edition of SQL Server. What does @.@.Version
>> show?
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
>> news:uJz3PVKaFHA.612@.TK2MSFTNGP12.phx.gbl...
>> Yes, SP4 installed
>> on a Win 2003 Enterprise edition server
>> AWE is NOT enable on the server.
>> For a 4Gb system what is the best option?
>> /3Gb
>> /3Gb + AWE
>> /PAE
>> /PAE + AWE
>> /3Gb /PAE
>> /3Gb /PAE + AWE
>> ?
>>
>> "David Gugick" <david.gugick-nospam@.quest.com> wrote in message
>> news:eYe9KLIaFHA.616@.TK2MSFTNGP12.phx.gbl...
>> Jéjé wrote:
>> Hi,
>> I have setup the /3Gb option in the boot.ini file because my server
>> has 4Gb of RAM.
>> But SQL Server still use only 1.7Gb.
>> on another server, there is no problems, the same parameters and SQL
>> Server use more then 2Gb of memory!!!
>> there is anything missing ?
>> what can I check?
>> thanks.
>> Jerome.
>> Are you running SQL 2000 Service Pack 4? If so, there's a known issue
>> with AWE that is going to be addressed with a hotfix in the next week
>> or two.
>> --
>> David Gugick
>> Quest Software
>> www.imceda.com
>> www.quest.com
>>
>>
>

Monday, March 19, 2012

/3gb memory switch

The properties of sql server (EE 2000) show that the
instance is set to dynamically allocate 0 - 3895 MB.
There are 4gb of ram on the server. However, the /3gb
memory switch is not set in the boot.ini file. It looks
like that this is what is happening -- sql server
recognizes all of the memory in the server, but the OS
prevents user processes from utilizing more than 2 GB. Is
this as expected? I'm getting ready to set the /3gb
switch and need a little reassurance. It is also my
understanding, that AWE does not need to be enabled when
dealing with a server with only 4GB of RAM. The only
change I need to make is the /3gb switch in the boot.ini
file -- can someone confirm?You are correct. /3B switch will allow the SQL process to use 3GB of user
memory instead of 2GB user memory.
AWE is for servers with greater than 4GB of physical memory.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"superboy" <anonymous@.discussions.microsoft.com> wrote in message
news:f92301c3f197$e266ced0$a501280a@.phx.gbl...
> The properties of sql server (EE 2000) show that the
> instance is set to dynamically allocate 0 - 3895 MB.
> There are 4gb of ram on the server. However, the /3gb
> memory switch is not set in the boot.ini file. It looks
> like that this is what is happening -- sql server
> recognizes all of the memory in the server, but the OS
> prevents user processes from utilizing more than 2 GB. Is
> this as expected? I'm getting ready to set the /3gb
> switch and need a little reassurance. It is also my
> understanding, that AWE does not need to be enabled when
> dealing with a server with only 4GB of RAM. The only
> change I need to make is the /3gb switch in the boot.ini
> file -- can someone confirm?

/3gb memory switch

The properties of sql server (EE 2000) show that the
instance is set to dynamically allocate 0 - 3895 MB.
There are 4gb of ram on the server. However, the /3gb
memory switch is not set in the boot.ini file. It looks
like that this is what is happening -- sql server
recognizes all of the memory in the server, but the OS
prevents user processes from utilizing more than 2 GB. Is
this as expected? I'm getting ready to set the /3gb
switch and need a little reassurance. It is also my
understanding, that AWE does not need to be enabled when
dealing with a server with only 4GB of RAM. The only
change I need to make is the /3gb switch in the boot.ini
file -- can someone confirm?You are correct. /3B switch will allow the SQL process to use 3GB of user
memory instead of 2GB user memory.
AWE is for servers with greater than 4GB of physical memory.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"superboy" <anonymous@.discussions.microsoft.com> wrote in message
news:f92301c3f197$e266ced0$a501280a@.phx.gbl...
> The properties of sql server (EE 2000) show that the
> instance is set to dynamically allocate 0 - 3895 MB.
> There are 4gb of ram on the server. However, the /3gb
> memory switch is not set in the boot.ini file. It looks
> like that this is what is happening -- sql server
> recognizes all of the memory in the server, but the OS
> prevents user processes from utilizing more than 2 GB. Is
> this as expected? I'm getting ready to set the /3gb
> switch and need a little reassurance. It is also my
> understanding, that AWE does not need to be enabled when
> dealing with a server with only 4GB of RAM. The only
> change I need to make is the /3gb switch in the boot.ini
> file -- can someone confirm?

/3GB benifits

What are the benifits of settings the 3gb switch and the userva=3030 in the
boot.ini of sql server 2000? thanks.
windows 2003 enterprise
4gb ram
sql server enterpriseHi,
Read the below article for more details.
http://www.sql-server-performance.com/awe_memory.asp
Thnks
Hari
SQL Server MVP
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:%2366kqs4TFHA.1796@.TK2MSFTNGP15.phx.gbl...
> What are the benifits of settings the 3gb switch and the userva=3030 in
the
> boot.ini of sql server 2000? thanks.
> windows 2003 enterprise
> 4gb ram
> sql server enterprise
>

/3GB and Maximum server memory

Also,
you really should set the limit for this to about 2.5-3GB to keep from
starving the OS and other necessary items of RAM.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Pieter" <pieterNOSPAMcoucke@.hotmail.com> wrote in message
news:u5h1fb6mIHA.3636@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
> activated the /3GB switch in the boot.ini, but I still can't setthe
> Maximum server memory any higher than 2147483647. What should I do else? I
> presume I should be able to set it until 3 gigabytes now?
>
> Any help will be really appreciated,
>
> Thansk a lot in advance,
>
> Pieter
> This is my boot.ini:
> [boot loader]
> timeout=30
> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOW S
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windo ws Server 2003,
> Standard" /noexecute=optout /fastdetect /3GB
>
|||Hi,
Indeed: In the mean time (when looking at the Task Manager) SQL Server is
using allmost 3 gigabytes, which is perfect!
Regarding the 2147483647: when you right click on the Server in the SQL
Server Management Studio, choose properties, and than Memory, you see the
Maximum server memory. But I guess it has nothing to do with it :-)
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:8DEA94EC-ACD9-4C2F-8C93-FE8B24FF7F94@.microsoft.com...[vbcol=seagreen]
> With /3GB switch alone, you should be able to see SQLServer:Buffer
> Manager\Total Pages or SQLServer:Memory Manager\Total Server Memory
> (KB)--both measuring the buffer pool--reach more than 2GB. But you
> probably
> won't see the buffer pool reach 3GB. Maybe, you didn't drive the SQL
> instance
> hard enough for it to use more than what you reported.
> See
> http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx
> for an exmaple.
> BTW, how did you get the 2147483647 number?
> Linchi
> "Pieter" wrote:

/3GB and Maximum server memory

Hi,
I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
activated the /3GB switch in the boot.ini, but I still can't setthe Maximum
server memory any higher than 2147483647. What should I do else? I presume I
should be able to set it until 3 gigabytes now?
Any help will be really appreciated,
Thansk a lot in advance,
Pieter
This is my boot.ini:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard"
/noexecute=optout /fastdetect /3GBWith /3GB switch alone, you should be able to see SQLServer:Buffer
Manager\Total Pages or SQLServer:Memory Manager\Total Server Memory
(KB)--both measuring the buffer pool--reach more than 2GB. But you probably
won't see the buffer pool reach 3GB. Maybe, you didn't drive the SQL instance
hard enough for it to use more than what you reported.
See
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx for an exmaple.
BTW, how did you get the 2147483647 number?
Linchi
"Pieter" wrote:
> Hi,
> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
> activated the /3GB switch in the boot.ini, but I still can't setthe Maximum
> server memory any higher than 2147483647. What should I do else? I presume I
> should be able to set it until 3 gigabytes now?
>
> Any help will be really appreciated,
>
> Thansk a lot in advance,
>
> Pieter
> This is my boot.ini:
> [boot loader]
> timeout=30
> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard"
> /noexecute=optout /fastdetect /3GB
>
>|||IIRC, that setting is in MEGABYTES, so it is far more than 4GB. :) Also,
you really should set the limit for this to about 2.5-3GB to keep from
starving the OS and other necessary items of RAM.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Pieter" <pieterNOSPAMcoucke@.hotmail.com> wrote in message
news:u5h1fb6mIHA.3636@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
> activated the /3GB switch in the boot.ini, but I still can't setthe
> Maximum server memory any higher than 2147483647. What should I do else? I
> presume I should be able to set it until 3 gigabytes now?
>
> Any help will be really appreciated,
>
> Thansk a lot in advance,
>
> Pieter
> This is my boot.ini:
> [boot loader]
> timeout=30
> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003,
> Standard" /noexecute=optout /fastdetect /3GB
>|||Hi,
Indeed: In the mean time (when looking at the Task Manager) SQL Server is
using allmost 3 gigabytes, which is perfect!
Regarding the 2147483647: when you right click on the Server in the SQL
Server Management Studio, choose properties, and than Memory, you see the
Maximum server memory. But I guess it has nothing to do with it :-)
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:8DEA94EC-ACD9-4C2F-8C93-FE8B24FF7F94@.microsoft.com...
> With /3GB switch alone, you should be able to see SQLServer:Buffer
> Manager\Total Pages or SQLServer:Memory Manager\Total Server Memory
> (KB)--both measuring the buffer pool--reach more than 2GB. But you
> probably
> won't see the buffer pool reach 3GB. Maybe, you didn't drive the SQL
> instance
> hard enough for it to use more than what you reported.
> See
> http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx
> for an exmaple.
> BTW, how did you get the 2147483647 number?
> Linchi
> "Pieter" wrote:
>> Hi,
>> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
>> activated the /3GB switch in the boot.ini, but I still can't setthe
>> Maximum
>> server memory any higher than 2147483647. What should I do else? I
>> presume I
>> should be able to set it until 3 gigabytes now?
>>
>> Any help will be really appreciated,
>>
>> Thansk a lot in advance,
>>
>> Pieter
>> This is my boot.ini:
>> [boot loader]
>> timeout=30
>> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
>> [operating systems]
>> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003,
>> Standard"
>> /noexecute=optout /fastdetect /3GB
>>

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

Tuesday, March 20, 2012

/3GB Switch

/3GB Switch

/3Gb option set, but SQL Server use only 1.7Gb....

Monday, March 19, 2012

/3gb memory switch

/3gb memory switch

/3GB benifits

/3GB and Maximum server memory

/3GB and Maximum server memory

/3gb

/3gb

/3gb

SQL SQLExpress

Blog Archive

About Me