8Gb RAM for SQL Server 2000 on Win 2003

What the setting should be (/3Gb, PAE, AWE) for the best utilization of
8GB RAM for SQL Server 2000 running on Win 2003?
Thanks
Hi,
After this you will have to do this:-
Probably you could configure 6 GB for SQL Server: Login as SA using query
analyzer and do:-
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Thanks
Hari
SQL Server MVP
"vlad" <vesmusor@.yahoo.com> wrote in message
news:1158846464.619887.179240@.h48g2000cwc.googlegr oups.com...
> What the setting should be (/3Gb, PAE, AWE) for the best utilization of
> 8GB RAM for SQL Server 2000 running on Win 2003?
> Thanks
>
|||Thanks for your reply, Hari. Does it mean I need to use both /3GB and
/PAE switches for this configuration?
Hari Prasad wrote:[vbcol=seagreen]
> Hi,
> After this you will have to do this:-
> Probably you could configure 6 GB for SQL Server: Login as SA using query
> analyzer and do:-
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> Thanks
> Hari
> SQL Server MVP
> "vlad" <vesmusor@.yahoo.com> wrote in message
> news:1158846464.619887.179240@.h48g2000cwc.googlegr oups.com...
|||You need to use PAE (and SQL Server use AWE) to have 32 but app on 32 bit OS access > 2GB memory.
Whether you use 3GB or not is up to you. For a system with 8BG memory, it is probably a good idea to
use 3GB. Google for "Slava Oks" and read the Blogs, this will give you more information so you
understand the ins and outs of setting 3GB, PAE and also AWE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"vlad" <vesmusor@.yahoo.com> wrote in message
news:1158848235.068934.133350@.i42g2000cwa.googlegr oups.com...
> Thanks for your reply, Hari. Does it mean I need to use both /3GB and
> /PAE switches for this configuration?
> Hari Prasad wrote:
>
|||Doesn't this all assume he's running Enterprise Edition of SQL Server?
I thought non enterprise version didn't address this much RAM?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eHS1C9a3GHA.3344@.TK2MSFTNGP05.phx.gbl...
> You need to use PAE (and SQL Server use AWE) to have 32 but app on 32 bit
> OS access > 2GB memory.
> Whether you use 3GB or not is up to you. For a system with 8BG memory, it
> is probably a good idea to use 3GB. Google for "Slava Oks" and read the
> Blogs, this will give you more information so you understand the ins and
> outs of setting 3GB, PAE and also AWE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "vlad" <vesmusor@.yahoo.com> wrote in message
> news:1158848235.068934.133350@.i42g2000cwa.googlegr oups.com...
>
|||Correct. I assumed EE as no edition was mentioned in the original post...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nick" <no.thanks@.nowhere.com> wrote in message news:enNh7uk3GHA.1796@.TK2MSFTNGP06.phx.gbl...
> Doesn't this all assume he's running Enterprise Edition of SQL Server?
> I thought non enterprise version didn't address this much RAM?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:eHS1C9a3GHA.3344@.TK2MSFTNGP05.phx.gbl...
>

8Gb RAM for SQL Server 2000 on Win 2003

What the setting should be (/3Gb, PAE, AWE) for the best utilization of
8GB RAM for SQL Server 2000 running on Win 2003?
ThanksHi,
After this you will have to do this:-
Probably you could configure 6 GB for SQL Server: Login as SA using query
analyzer and do:-
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Thanks
Hari
SQL Server MVP
"vlad" <vesmusor@.yahoo.com> wrote in message
news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...
> What the setting should be (/3Gb, PAE, AWE) for the best utilization of
> 8GB RAM for SQL Server 2000 running on Win 2003?
> Thanks
>|||Thanks for your reply, Hari. Does it mean I need to use both /3GB and
/PAE switches for this configuration?
Hari Prasad wrote:
> Hi,
> After this you will have to do this:-
> Probably you could configure 6 GB for SQL Server: Login as SA using query
> analyzer and do:-
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> Thanks
> Hari
> SQL Server MVP
> "vlad" <vesmusor@.yahoo.com> wrote in message
> news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...
> > What the setting should be (/3Gb, PAE, AWE) for the best utilization of
> > 8GB RAM for SQL Server 2000 running on Win 2003?
> >
> > Thanks
> >|||You need to use PAE (and SQL Server use AWE) to have 32 but app on 32 bit OS access > 2GB memory.
Whether you use 3GB or not is up to you. For a system with 8BG memory, it is probably a good idea to
use 3GB. Google for "Slava Oks" and read the Blogs, this will give you more information so you
understand the ins and outs of setting 3GB, PAE and also AWE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"vlad" <vesmusor@.yahoo.com> wrote in message
news:1158848235.068934.133350@.i42g2000cwa.googlegroups.com...
> Thanks for your reply, Hari. Does it mean I need to use both /3GB and
> /PAE switches for this configuration?
> Hari Prasad wrote:
>> Hi,
>> After this you will have to do this:-
>> Probably you could configure 6 GB for SQL Server: Login as SA using query
>> analyzer and do:-
>> sp_configure 'show advanced options', 1
>> RECONFIGURE
>> GO
>> sp_configure 'awe enabled', 1
>> RECONFIGURE
>> GO
>> sp_configure 'max server memory', 6144
>> RECONFIGURE
>> GO
>> Thanks
>> Hari
>> SQL Server MVP
>> "vlad" <vesmusor@.yahoo.com> wrote in message
>> news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...
>> > What the setting should be (/3Gb, PAE, AWE) for the best utilization of
>> > 8GB RAM for SQL Server 2000 running on Win 2003?
>> >
>> > Thanks
>> >
>|||Doesn't this all assume he's running Enterprise Edition of SQL Server?
I thought non enterprise version didn't address this much RAM?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eHS1C9a3GHA.3344@.TK2MSFTNGP05.phx.gbl...
> You need to use PAE (and SQL Server use AWE) to have 32 but app on 32 bit
> OS access > 2GB memory.
> Whether you use 3GB or not is up to you. For a system with 8BG memory, it
> is probably a good idea to use 3GB. Google for "Slava Oks" and read the
> Blogs, this will give you more information so you understand the ins and
> outs of setting 3GB, PAE and also AWE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "vlad" <vesmusor@.yahoo.com> wrote in message
> news:1158848235.068934.133350@.i42g2000cwa.googlegroups.com...
>> Thanks for your reply, Hari. Does it mean I need to use both /3GB and
>> /PAE switches for this configuration?
>> Hari Prasad wrote:
>> Hi,
>> After this you will have to do this:-
>> Probably you could configure 6 GB for SQL Server: Login as SA using
>> query
>> analyzer and do:-
>> sp_configure 'show advanced options', 1
>> RECONFIGURE
>> GO
>> sp_configure 'awe enabled', 1
>> RECONFIGURE
>> GO
>> sp_configure 'max server memory', 6144
>> RECONFIGURE
>> GO
>> Thanks
>> Hari
>> SQL Server MVP
>> "vlad" <vesmusor@.yahoo.com> wrote in message
>> news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...
>> > What the setting should be (/3Gb, PAE, AWE) for the best utilization
>> > of
>> > 8GB RAM for SQL Server 2000 running on Win 2003?
>> >
>> > Thanks
>> >
>|||Correct. I assumed EE as no edition was mentioned in the original post...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nick" <no.thanks@.nowhere.com> wrote in message news:enNh7uk3GHA.1796@.TK2MSFTNGP06.phx.gbl...
> Doesn't this all assume he's running Enterprise Edition of SQL Server?
> I thought non enterprise version didn't address this much RAM?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:eHS1C9a3GHA.3344@.TK2MSFTNGP05.phx.gbl...
>> You need to use PAE (and SQL Server use AWE) to have 32 but app on 32 bit
>> OS access > 2GB memory.
>> Whether you use 3GB or not is up to you. For a system with 8BG memory, it
>> is probably a good idea to use 3GB. Google for "Slava Oks" and read the
>> Blogs, this will give you more information so you understand the ins and
>> outs of setting 3GB, PAE and also AWE.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "vlad" <vesmusor@.yahoo.com> wrote in message
>> news:1158848235.068934.133350@.i42g2000cwa.googlegroups.com...
>> Thanks for your reply, Hari. Does it mean I need to use both /3GB and
>> /PAE switches for this configuration?
>> Hari Prasad wrote:
>> Hi,
>> After this you will have to do this:-
>> Probably you could configure 6 GB for SQL Server: Login as SA using
>> query
>> analyzer and do:-
>> sp_configure 'show advanced options', 1
>> RECONFIGURE
>> GO
>> sp_configure 'awe enabled', 1
>> RECONFIGURE
>> GO
>> sp_configure 'max server memory', 6144
>> RECONFIGURE
>> GO
>> Thanks
>> Hari
>> SQL Server MVP
>> "vlad" <vesmusor@.yahoo.com> wrote in message
>> news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...
>> > What the setting should be (/3Gb, PAE, AWE) for the best utilization
>> > of
>> > 8GB RAM for SQL Server 2000 running on Win 2003?
>> >
>> > Thanks
>> >
>>
>

8Gb RAM for SQL Server 2000 on Win 2003

What the setting should be (/3Gb, PAE, AWE) for the best utilization of
8GB RAM for SQL Server 2000 running on Win 2003?
ThanksHi,
After this you will have to do this:-
Probably you could configure 6 GB for SQL Server: Login as SA using query
analyzer and do:-
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Thanks
Hari
SQL Server MVP
"vlad" <vesmusor@.yahoo.com> wrote in message
news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...
> What the setting should be (/3Gb, PAE, AWE) for the best utilization of
> 8GB RAM for SQL Server 2000 running on Win 2003?
> Thanks
>|||Thanks for your reply, Hari. Does it mean I need to use both /3GB and
/PAE switches for this configuration?
Hari Prasad wrote:[vbcol=seagreen]
> Hi,
> After this you will have to do this:-
> Probably you could configure 6 GB for SQL Server: Login as SA using query
> analyzer and do:-
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> Thanks
> Hari
> SQL Server MVP
> "vlad" <vesmusor@.yahoo.com> wrote in message
> news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...|||You need to use PAE (and SQL Server use AWE) to have 32 but app on 32 bit OS
access > 2GB memory.
Whether you use 3GB or not is up to you. For a system with 8BG memory, it is
probably a good idea to
use 3GB. Google for "Slava Oks" and read the Blogs, this will give you more
information so you
understand the ins and outs of setting 3GB, PAE and also AWE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"vlad" <vesmusor@.yahoo.com> wrote in message
news:1158848235.068934.133350@.i42g2000cwa.googlegroups.com...
> Thanks for your reply, Hari. Does it mean I need to use both /3GB and
> /PAE switches for this configuration?
> Hari Prasad wrote:
>|||Doesn't this all assume he's running Enterprise Edition of SQL Server?
I thought non enterprise version didn't address this much RAM?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eHS1C9a3GHA.3344@.TK2MSFTNGP05.phx.gbl...
> You need to use PAE (and SQL Server use AWE) to have 32 but app on 32 bit
> OS access > 2GB memory.
> Whether you use 3GB or not is up to you. For a system with 8BG memory, it
> is probably a good idea to use 3GB. Google for "Slava Oks" and read the
> Blogs, this will give you more information so you understand the ins and
> outs of setting 3GB, PAE and also AWE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "vlad" <vesmusor@.yahoo.com> wrote in message
> news:1158848235.068934.133350@.i42g2000cwa.googlegroups.com...
>|||Correct. I assumed EE as no edition was mentioned in the original post...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nick" <no.thanks@.nowhere.com> wrote in message news:enNh7uk3GHA.1796@.TK2MSFTNGP06.phx.gbl..
.
> Doesn't this all assume he's running Enterprise Edition of SQL Server?
> I thought non enterprise version didn't address this much RAM?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:eHS1C9a3GHA.3344@.TK2MSFTNGP05.phx.gbl...
>

6G Ram but SQL doesn't make use of it by default

If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
I have made a new fresh setup (everything is in 64 bit version) on a brand
new machine with 6Gigs of RAM, still when I display server's properties, in
the memory section, in the textbox under Max Server memory
I have 2147483647, which I think is 2 G
ThanksYou shouldn't have to do any config on a 64 bit SS on a 64 bit machine for using > 2GB memory.
> I have 2147483647, which I think is 2 G
No, that number is in MB:
2147483647 MB
= 2097151 GB
= 2047 TB
= approx 2 PB (it is Peta or Exa?)
No discussion on memory and 64 bit is complete without referring to Slava Oks blogs. In short,
consider using lock pages in memory also on 64 bit (if my memory serves me):
http://blogs.msdn.com/slavao/archive/category/9043.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties, in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks|||2147483647 is much more than 2GB... 1024 = 1GB
--
Keith Kratochvil
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties,
> in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks|||Hi Salam,
As other members have mentioned, the 2147483647 default value is in MB, so
it is a quite large value( you need to reduce it according to your
machine's physical memory).
As for AWE, it is an operating system feature and is only useful when the
virtual address space(of OS process) is less than the available physical
memory. For SQL server 2005 64 bit on windows 2003 64 bit, there is no
such virtual address space limitation(normally virtual address space is
much larger than available physical memory space). also, it is recommended
that we adjust the SQL Server instance's max server memory to a proper
value so that other applications on the server can also get sufficient
physical memory for paging file switch.
#Enabling AWE Memory for SQL Server
http://msdn2.microsoft.com/en-us/library/ms190673.aspx
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Salam,
Have you got any further idea on this issue? Please feel free to post here
if there is anything else we can help.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

64 bit memory and AWE ?

Hi There

I have installed 64 bit Standard Edition SS 2005 on a 64 bit WOndows Server 2003 R2 platform.

When i go to Memory setting for this instance i set max server memory to 6 Gig.

I am presuming i do not have to enable AWE, sicne everything is 64 bit.

Is this correct ?

Thanx

AWE is used for 32-bit OS due to 32-bit system can only address 4GB memory in conventual way, so it need to set /PAE in boot.ini file and set AWE enabled in SQL server.

but for 64-bit OS and SQL server (both 2000 and 2005) do not need to set this option.

64 bit memory and AWE ?

Hi There

I have installed 64 bit Standard Edition SS 2005 on a 64 bit WOndows Server 2003 R2 platform.

When i go to Memory setting for this instance i set max server memory to 6 Gig.

I am presuming i do not have to enable AWE, sicne everything is 64 bit.

Is this correct ?

Thanx

AWE is used for 32-bit OS due to 32-bit system can only address 4GB memory in conventual way, so it need to set /PAE in boot.ini file and set AWE enabled in SQL server.

but for 64-bit OS and SQL server (both 2000 and 2005) do not need to set this option.

4->8GB RAM Upgrade

I've recently upgraded a SQL 2000 Server from 4GB to 8GB of RAM. PAE, 3GB and AWE were enabled - AWE was set to ~6GB. The target SQL memory was around 4.1GB and the total SQL memory in use matched that. The VERY odd thing is this did nothing at all to help performance. It almost seems that it hampered it. Any ideas out there?

Read about AWE in 2005...

It explains that the extra memory is not used for sorts and other things that you think it would be...

Bret.

|||

Sorry...I didn't make that clear...

In 2000 it is not used for sorts and other things that would increase performance...

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

3GB once again

Hi,
No there is no memory Limit for SQL Standard edition.. Using SP_CONFIGURE enable the option 'AWE Enabled' by setting the value to 1. After that set the max server memory
value to 3 GB for your SQL Server.
Thanks
Hari
"Axel Bender" <axel_bender@.t-online.de> wrote in message news:eq76ee$unj$00$1@.news.t-online.com...
Hi,
In the following configuration:
- SQL Server 2005 Standard SP1
- Windows 2003 Server R2 Standard
- 4 GB physical memory
- /3GB and /UserVA=3072 in boot.ini
the maximum amount of memory I can configure SQL Server to use (Options dialog) is 2 GB.
I found contradictory statements in the Web (see below) as well as in the MS SQL Server docs (limited by OS memory) for the Standard Edition.
Is there a 2 GB limit for SQL Server 2005 Standard on Windows 2003 Server?
thx
Axel
Hari
It is correct to 32 bit version as I understood . For 64 bit version you have to grant permission to the account on Lock Page memory and there is not reason to enable AWE.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message news:OQf$TaSSHHA.4260@.TK2MSFTNGP06.phx.gbl...
Hi,
No there is no memory Limit for SQL Standard edition.. Using SP_CONFIGURE enable the option 'AWE Enabled' by setting the value to 1. After that set the max server memory
value to 3 GB for your SQL Server.
Thanks
Hari
"Axel Bender" <axel_bender@.t-online.de> wrote in message news:eq76ee$unj$00$1@.news.t-online.com...
Hi,
In the following configuration:
- SQL Server 2005 Standard SP1
- Windows 2003 Server R2 Standard
- 4 GB physical memory
- /3GB and /UserVA=3072 in boot.ini
the maximum amount of memory I can configure SQL Server to use (Options dialog) is 2 GB.
I found contradictory statements in the Web (see below) as well as in the MS SQL Server docs (limited by OS memory) for the Standard Edition.
Is there a 2 GB limit for SQL Server 2005 Standard on Windows 2003 Server?
thx
Axel