|
Home > Archive > MS SQL Server > October 2006 > 8Gb RAM for SQL Server 2000 on Win 2003
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Hari Prasad 2006-10-24, 6:30 pm |
| 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
>
| |
|
| Thanks for your reply, Hari. Does it mean I need to use both /3GB and
/PAE switches for this configuration?
Hari Prasad wrote:[color=darkred
]
> 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...
| |
| Tibor Karaszi 2006-10-24, 6:30 pm |
| 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@hotmai
l.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...
>
| |
| Tibor Karaszi 2006-10-24, 6:30 pm |
| 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@hotmai
l.nomail.com> wrote in
> message news:eHS1C9a3GHA.3344@TK2MSFTNGP05.phx.gbl...
>
>
|
|
|
|
|