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

8 GB of RAM

I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
Standard.
I have the switches /PAE /3GB in boot.ini
SQL max server memory is = 6656 MB
but with those settings I cannot get SQLServer to get more than 2.7 GB
of RAM
If I use the AWE switch, then SQLServer can only use 128 MB max
What's wrong?
PaulOn Dec 4, 3:42 am, pd...@.clic.net wrote:
> I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
> Standard.
> I have the switches /PAE /3GB in boot.ini
> SQL max server memory is = 6656 MB
> but with those settings I cannot get SQLServer to get more than 2.7 GB
> of RAM
> If I use the AWE switch, then SQLServer can only use 128 MB max
> What's wrong?
> Paul
Is it SQL Server 2000 or SQL Server 2005?
If its SQL Server 2000, then AWE is not supported
If its SQL Server 2005, then check the AWE 'Run Value' in
sp_configure... if its 0, then you might want to recycle the SQL
Server service to enable the AWE
In any case i dont believe you need to have /3GB switch in boot.ini.|||Hey, of course you can use AWE on SQL Server 2000 (and also on SQL Server
2005).
You will need to run
sp_configure 'awe enabled', 1
and grant the Lock Page in Memory permission to your service account. For
more details see
How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"dineshbabu.munugala@.gmail.com" wrote:
> On Dec 4, 3:42 am, pd...@.clic.net wrote:
> > I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
> > Standard.
> > I have the switches /PAE /3GB in boot.ini
> >
> > SQL max server memory is = 6656 MB
> >
> > but with those settings I cannot get SQLServer to get more than 2.7 GB
> > of RAM
> >
> > If I use the AWE switch, then SQLServer can only use 128 MB max
> >
> > What's wrong?
> >
> > Paul
> Is it SQL Server 2000 or SQL Server 2005?
> If its SQL Server 2000, then AWE is not supported
> If its SQL Server 2005, then check the AWE 'Run Value' in
> sp_configure... if its 0, then you might want to recycle the SQL
> Server service to enable the AWE
> In any case i dont believe you need to have /3GB switch in boot.ini.
>|||Ben
If you are on 64-bit , you do not need AWE anymore. If the OP has SQL Server
2000 along with SP4 , make sure that he has a last hotfix especially if he
are going to enable AWE
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:2ADA35D9-C4FA-4852-B20A-3E08F240C626@.microsoft.com...
> Hey, of course you can use AWE on SQL Server 2000 (and also on SQL Server
> 2005).
> You will need to run
> sp_configure 'awe enabled', 1
> and grant the Lock Page in Memory permission to your service account. For
> more details see
> How to configure SQL Server to use more than 2 GB of physical memory
> http://support.microsoft.com/kb/274750
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "dineshbabu.munugala@.gmail.com" wrote:
>> On Dec 4, 3:42 am, pd...@.clic.net wrote:
>> > I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
>> > Standard.
>> > I have the switches /PAE /3GB in boot.ini
>> >
>> > SQL max server memory is = 6656 MB
>> >
>> > but with those settings I cannot get SQLServer to get more than 2.7 GB
>> > of RAM
>> >
>> > If I use the AWE switch, then SQLServer can only use 128 MB max
>> >
>> > What's wrong?
>> >
>> > Paul
>> Is it SQL Server 2000 or SQL Server 2005?
>> If its SQL Server 2000, then AWE is not supported
>> If its SQL Server 2005, then check the AWE 'Run Value' in
>> sp_configure... if its 0, then you might want to recycle the SQL
>> Server service to enable the AWE
>> In any case i dont believe you need to have /3GB switch in boot.ini.|||On 3 d=E9c, 18:04, dineshbabu.munug...@.gmail.com wrote:
> On Dec 4, 3:42 am, pd...@.clic.net wrote:
> > I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
> > Standard.
> > I have the switches /PAE /3GB in boot.ini
> > SQL max server memory is =3D 6656 MB
> > but with those settings I cannot get SQLServer to get more than 2.7 GB
> > of RAM
> > If I use the AWE switch, then SQLServer can only use 128 MB max
> > What's wrong?
> > Paul
> Is it SQL Server 2000 or SQL Server 2005?
> If its SQL Server 2000, then AWE is not supported
> If its SQL Server 2005, then check the AWE 'Run Value' in
> sp_configure... if its 0, then you might want to recycle the SQL
> Server service to enable the AWE
> In any case i dont believe you need to have /3GB switch in boot.ini.
SQL2005 Standard.
Running in 32 bits system
As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
(i.e. I run dbcc checkDB so that it starts using rapidly memory and I
see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
Paul|||Hi
Do you have SP4 with hotfix?
Install hotfix from(http://support.microsoft.com/kb/899761)
Do you see in PerfMon that SQL Server allocate 6.6GB RAM?
<pdube@.clic.net> wrote in message
news:e4a9b19a-1b95-4df7-b6d9-e8c374bfb9c0@.a39g2000pre.googlegroups.com...
On 3 déc, 18:04, dineshbabu.munug...@.gmail.com wrote:
> On Dec 4, 3:42 am, pd...@.clic.net wrote:
> > I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
> > Standard.
> > I have the switches /PAE /3GB in boot.ini
> > SQL max server memory is = 6656 MB
> > but with those settings I cannot get SQLServer to get more than 2.7 GB
> > of RAM
> > If I use the AWE switch, then SQLServer can only use 128 MB max
> > What's wrong?
> > Paul
> Is it SQL Server 2000 or SQL Server 2005?
> If its SQL Server 2000, then AWE is not supported
> If its SQL Server 2005, then check the AWE 'Run Value' in
> sp_configure... if its 0, then you might want to recycle the SQL
> Server service to enable the AWE
> In any case i dont believe you need to have /3GB switch in boot.ini.
SQL2005 Standard.
Running in 32 bits system
As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
(i.e. I run dbcc checkDB so that it starts using rapidly memory and I
see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
Paul|||On 4 d=E9c, 10:45, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hi
> Do you have SP4 with hotfix?
> Install hotfix from(http://support.microsoft.com/kb/899761)
> Do you see in PerfMon that SQL Server allocate 6.6GB RAM?
> <pd...@.clic.net> wrote in message
> news:e4a9b19a-1b95-4df7-b6d9-e8c374bfb9c0@.a39g2000pre.googlegroups.com...
> On 3 d=E9c, 18:04, dineshbabu.munug...@.gmail.com wrote:
>
>
> > On Dec 4, 3:42 am, pd...@.clic.net wrote:
> > > I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
> > > Standard.
> > > I have the switches /PAE /3GB in boot.ini
> > > SQL max server memory is =3D 6656 MB
> > > but with those settings I cannot get SQLServer to get more than 2.7 GB=
> > > of RAM
> > > If I use the AWE switch, then SQLServer can only use 128 MB max
> > > What's wrong?
> > > Paul
> > Is it SQL Server 2000 or SQL Server 2005?
> > If its SQL Server 2000, then AWE is not supported
> > If its SQL Server 2005, then check the AWE 'Run Value' in
> > sp_configure... if its 0, then you might want to recycle the SQL
> > Server service to enable the AWE
> > In any case i dont believe you need to have /3GB switch in boot.ini.
> SQL2005 Standard.
> Running in 32 bits system
> As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
> (i.e. I run dbcc checkDB so that it starts using rapidly memory and I
> see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
> Paul- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -
SQL 2005 (9.00.3161.00)
The hotfix is for SQL 2000...
In PerfMon, I see Commited Bytes around 3.2 GB.
In Task Manager I still see SQLServer.exe using 2.7 GB. I guess then
that's just a problem related with Task Manager not showing the
correct amount of RAM used...?
Paul|||On 4 d=E9c, 14:08, pd...@.clic.net wrote:
> On 4 d=E9c, 10:45, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
>
> > Hi
> > Do you have SP4 with hotfix?
> > Install hotfix from(http://support.microsoft.com/kb/899761)
> > Do you see in PerfMon that SQL Server allocate 6.6GB RAM?
> > <pd...@.clic.net> wrote in message
> >news:e4a9b19a-1b95-4df7-b6d9-e8c374bfb9c0@.a39g2000pre.googlegroups.com...=
> > On 3 d=E9c, 18:04, dineshbabu.munug...@.gmail.com wrote:
> > > On Dec 4, 3:42 am, pd...@.clic.net wrote:
> > > > I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server=
> > > > Standard.
> > > > I have the switches /PAE /3GB in boot.ini
> > > > SQL max server memory is =3D 6656 MB
> > > > but with those settings I cannot get SQLServer to get more than 2.7 =GB
> > > > of RAM
> > > > If I use the AWE switch, then SQLServer can only use 128 MB max
> > > > What's wrong?
> > > > Paul
> > > Is it SQL Server 2000 or SQL Server 2005?
> > > If its SQL Server 2000, then AWE is not supported
> > > If its SQL Server 2005, then check the AWE 'Run Value' in
> > > sp_configure... if its 0, then you might want to recycle the SQL
> > > Server service to enable the AWE
> > > In any case i dont believe you need to have /3GB switch in boot.ini.
> > SQL2005 Standard.
> > Running in 32 bits system
> > As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
> > (i.e. I run dbcc checkDB so that it starts using rapidly memory and I
> > see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
> > Paul- Masquer le texte des messages pr=E9c=E9dents -
> > - Afficher le texte des messages pr=E9c=E9dents -
> SQL 2005 (9.00.3161.00)
> The hotfix is for SQL 2000...
> In PerfMon, I see Commited Bytes around 3.2 GB.
> In Task Manager I still see SQLServer.exe using 2.7 GB. I guess then
> that's just a problem related with Task Manager not showing the
> correct amount of RAM used...?
> Paul- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -
When I say that I see 128 MB of RAM in SQLServer.exe when using AWE I
mean that's what I see in Task Manager. Am I correct looking at this
value?
Should I check PerfMon instead? Is the memory shown in TaskManager
only kernel memory and would not show all memory used by SQL?
Paul|||SP4 hotfix is not needed here as this is SQL Server 2005.
Try this to see how much memory SQL Server is using. Performance Monitor,
add SQLServer:Memory Manager - Total Server Memory (KB).
Have you granted the Lock Page in Memory permission to your service account?
See your Error log. Must show 'Address Windowing Extensions enabled' or some
AWE error message.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Uri Dimant" wrote:
> Hi
> Do you have SP4 with hotfix?
> Install hotfix from(http://support.microsoft.com/kb/899761)
> Do you see in PerfMon that SQL Server allocate 6.6GB RAM?
>
>
> <pdube@.clic.net> wrote in message
> news:e4a9b19a-1b95-4df7-b6d9-e8c374bfb9c0@.a39g2000pre.googlegroups.com...
> On 3 déc, 18:04, dineshbabu.munug...@.gmail.com wrote:
> > On Dec 4, 3:42 am, pd...@.clic.net wrote:
> >
> > > I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
> > > Standard.
> > > I have the switches /PAE /3GB in boot.ini
> >
> > > SQL max server memory is = 6656 MB
> >
> > > but with those settings I cannot get SQLServer to get more than 2.7 GB
> > > of RAM
> >
> > > If I use the AWE switch, then SQLServer can only use 128 MB max
> >
> > > What's wrong?
> >
> > > Paul
> >
> > Is it SQL Server 2000 or SQL Server 2005?
> > If its SQL Server 2000, then AWE is not supported
> > If its SQL Server 2005, then check the AWE 'Run Value' in
> > sp_configure... if its 0, then you might want to recycle the SQL
> > Server service to enable the AWE
> >
> > In any case i dont believe you need to have /3GB switch in boot.ini.
> SQL2005 Standard.
> Running in 32 bits system
> As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
> (i.e. I run dbcc checkDB so that it starts using rapidly memory and I
> see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
> Paul
>
>|||Sorry. I missed that you are on SQL Server 2005.
In 32 -bit you do need AWE and as Ben pointed out gran permission Lock
Page in Memory permission to your service account.
To see if SQL server uses 6GB open PerfMonitor , do not use Task Manager
Visit also http://blogs.msdn.com/slavao/
<pdube@.clic.net> wrote in message
news:f9c9559b-d836-4b7f-92d4-bfc8834aab35@.s36g2000prg.googlegroups.com...
On 4 déc, 14:08, pd...@.clic.net wrote:
> On 4 déc, 10:45, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
>
> > Hi
> > Do you have SP4 with hotfix?
> > Install hotfix from(http://support.microsoft.com/kb/899761)
> > Do you see in PerfMon that SQL Server allocate 6.6GB RAM?
> > <pd...@.clic.net> wrote in message
> >news:e4a9b19a-1b95-4df7-b6d9-e8c374bfb9c0@.a39g2000pre.googlegroups.com...
> > On 3 déc, 18:04, dineshbabu.munug...@.gmail.com wrote:
> > > On Dec 4, 3:42 am, pd...@.clic.net wrote:
> > > > I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
> > > > Standard.
> > > > I have the switches /PAE /3GB in boot.ini
> > > > SQL max server memory is = 6656 MB
> > > > but with those settings I cannot get SQLServer to get more than 2.7
> > > > GB
> > > > of RAM
> > > > If I use the AWE switch, then SQLServer can only use 128 MB max
> > > > What's wrong?
> > > > Paul
> > > Is it SQL Server 2000 or SQL Server 2005?
> > > If its SQL Server 2000, then AWE is not supported
> > > If its SQL Server 2005, then check the AWE 'Run Value' in
> > > sp_configure... if its 0, then you might want to recycle the SQL
> > > Server service to enable the AWE
> > > In any case i dont believe you need to have /3GB switch in boot.ini.
> > SQL2005 Standard.
> > Running in 32 bits system
> > As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
> > (i.e. I run dbcc checkDB so that it starts using rapidly memory and I
> > see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
> > Paul- Masquer le texte des messages précédents -
> > - Afficher le texte des messages précédents -
> SQL 2005 (9.00.3161.00)
> The hotfix is for SQL 2000...
> In PerfMon, I see Commited Bytes around 3.2 GB.
> In Task Manager I still see SQLServer.exe using 2.7 GB. I guess then
> that's just a problem related with Task Manager not showing the
> correct amount of RAM used...?
> Paul- Masquer le texte des messages précédents -
> - Afficher le texte des messages précédents -
When I say that I see 128 MB of RAM in SQLServer.exe when using AWE I
mean that's what I see in Task Manager. Am I correct looking at this
value?
Should I check PerfMon instead? Is the memory shown in TaskManager
only kernel memory and would not show all memory used by SQL?
Paul

8 GB of RAM

I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
Standard.
I have the switches /PAE /3GB in boot.ini
SQL max server memory is = 6656 MB
but with those settings I cannot get SQLServer to get more than 2.7 GB
of RAM
If I use the AWE switch, then SQLServer can only use 128 MB max
What's wrong?
Paul
On Dec 4, 3:42 am, pd...@.clic.net wrote:
> I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
> Standard.
> I have the switches /PAE /3GB in boot.ini
> SQL max server memory is = 6656 MB
> but with those settings I cannot get SQLServer to get more than 2.7 GB
> of RAM
> If I use the AWE switch, then SQLServer can only use 128 MB max
> What's wrong?
> Paul
Is it SQL Server 2000 or SQL Server 2005?
If its SQL Server 2000, then AWE is not supported
If its SQL Server 2005, then check the AWE 'Run Value' in
sp_configure... if its 0, then you might want to recycle the SQL
Server service to enable the AWE
In any case i dont believe you need to have /3GB switch in boot.ini.
|||Hey, of course you can use AWE on SQL Server 2000 (and also on SQL Server
2005).
You will need to run
sp_configure 'awe enabled', 1
and grant the Lock Page in Memory permission to your service account. For
more details see
How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"dineshbabu.munugala@.gmail.com" wrote:

> On Dec 4, 3:42 am, pd...@.clic.net wrote:
> Is it SQL Server 2000 or SQL Server 2005?
> If its SQL Server 2000, then AWE is not supported
> If its SQL Server 2005, then check the AWE 'Run Value' in
> sp_configure... if its 0, then you might want to recycle the SQL
> Server service to enable the AWE
> In any case i dont believe you need to have /3GB switch in boot.ini.
>
|||Ben
If you are on 64-bit , you do not need AWE anymore. If the OP has SQL Server
2000 along with SP4 , make sure that he has a last hotfix especially if he
are going to enable AWE
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:2ADA35D9-C4FA-4852-B20A-3E08F240C626@.microsoft.com...[vbcol=seagreen]
> Hey, of course you can use AWE on SQL Server 2000 (and also on SQL Server
> 2005).
> You will need to run
> sp_configure 'awe enabled', 1
> and grant the Lock Page in Memory permission to your service account. For
> more details see
> How to configure SQL Server to use more than 2 GB of physical memory
> http://support.microsoft.com/kb/274750
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "dineshbabu.munugala@.gmail.com" wrote:
|||On 3 dc, 18:04, dineshbabu.munug...@.gmail.com wrote:
> On Dec 4, 3:42 am, pd...@.clic.net wrote:
>
>
>
> Is it SQL Server 2000 or SQL Server 2005?
> If its SQL Server 2000, then AWE is not supported
> If its SQL Server 2005, then check the AWE 'Run Value' in
> sp_configure... if its 0, then you might want to recycle the SQL
> Server service to enable the AWE
> In any case i dont believe you need to have /3GB switch in boot.ini.
SQL2005 Standard.
Running in 32 bits system
As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
(i.e. I run dbcc checkDB so that it starts using rapidly memory and I
see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
Paul
|||Hi
Do you have SP4 with hotfix?
Install hotfix from(http://support.microsoft.com/kb/899761)
Do you see in PerfMon that SQL Server allocate 6.6GB RAM?
<pdube@.clic.net> wrote in message
news:e4a9b19a-1b95-4df7-b6d9-e8c374bfb9c0@.a39g2000pre.googlegroups.com...
On 3 dc, 18:04, dineshbabu.munug...@.gmail.com wrote:
> On Dec 4, 3:42 am, pd...@.clic.net wrote:
>
>
>
> Is it SQL Server 2000 or SQL Server 2005?
> If its SQL Server 2000, then AWE is not supported
> If its SQL Server 2005, then check the AWE 'Run Value' in
> sp_configure... if its 0, then you might want to recycle the SQL
> Server service to enable the AWE
> In any case i dont believe you need to have /3GB switch in boot.ini.
SQL2005 Standard.
Running in 32 bits system
As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
(i.e. I run dbcc checkDB so that it starts using rapidly memory and I
see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
Paul
|||On 4 dc, 10:45, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hi
> Do you have SP4 with hotfix?
> Install hotfix from(http://support.microsoft.com/kb/899761)
> Do you see in PerfMon that SQL Server allocate 6.6GB RAM?
> <pd...@.clic.net> wrote in message
> news:e4a9b19a-1b95-4df7-b6d9-e8c374bfb9c0@.a39g2000pre.googlegroups.com...
> On 3 dc, 18:04, dineshbabu.munug...@.gmail.com wrote:
>
>
>
>
>
>
>
> SQL2005 Standard.
> Running in 32 bits system
> As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
> (i.e. I run dbcc checkDB so that it starts using rapidly memory and I
> see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
> Paul- Masquer le texte des messages prcdents -
> - Afficher le texte des messages prcdents -
SQL 2005 (9.00.3161.00)
The hotfix is for SQL 2000...
In PerfMon, I see Commited Bytes around 3.2 GB.
In Task Manager I still see SQLServer.exe using 2.7 GB. I guess then
that's just a problem related with Task Manager not showing the
correct amount of RAM used...?
Paul
|||On 4 dc, 14:08, pd...@.clic.net wrote:
> On 4 dc, 10:45, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
>
>
>
>
>
>
>
>
>
> SQL 2005 (9.00.3161.00)
> The hotfix is for SQL 2000...
> In PerfMon, I see Commited Bytes around 3.2 GB.
> In Task Manager I still see SQLServer.exe using 2.7 GB. I guess then
> that's just a problem related with Task Manager not showing the
> correct amount of RAM used...?
> Paul- Masquer le texte des messages prcdents -
> - Afficher le texte des messages prcdents -
When I say that I see 128 MB of RAM in SQLServer.exe when using AWE I
mean that's what I see in Task Manager. Am I correct looking at this
value?
Should I check PerfMon instead? Is the memory shown in TaskManager
only kernel memory and would not show all memory used by SQL?
Paul
|||SP4 hotfix is not needed here as this is SQL Server 2005.
Try this to see how much memory SQL Server is using. Performance Monitor,
add SQLServer:Memory Manager - Total Server Memory (KB).
Have you granted the Lock Page in Memory permission to your service account?
See your Error log. Must show 'Address Windowing Extensions enabled' or some
AWE error message.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Uri Dimant" wrote:

> Hi
> Do you have SP4 with hotfix?
> Install hotfix from(http://support.microsoft.com/kb/899761)
> Do you see in PerfMon that SQL Server allocate 6.6GB RAM?
>
>
> <pdube@.clic.net> wrote in message
> news:e4a9b19a-1b95-4df7-b6d9-e8c374bfb9c0@.a39g2000pre.googlegroups.com...
> On 3 déc, 18:04, dineshbabu.munug...@.gmail.com wrote:
> SQL2005 Standard.
> Running in 32 bits system
> As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
> (i.e. I run dbcc checkDB so that it starts using rapidly memory and I
> see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
> Paul
>
>
|||Sorry. I missed that you are on SQL Server 2005.
In 32 -bit you do need AWE and as Ben pointed out gran permission Lock
Page in Memory permission to your service account.
To see if SQL server uses 6GB open PerfMonitor , do not use Task Manager
Visit also http://blogs.msdn.com/slavao/
<pdube@.clic.net> wrote in message
news:f9c9559b-d836-4b7f-92d4-bfc8834aab35@.s36g2000prg.googlegroups.com...
On 4 dc, 14:08, pd...@.clic.net wrote:
> On 4 dc, 10:45, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
>
>
>
>
>
>
>
>
>
> SQL 2005 (9.00.3161.00)
> The hotfix is for SQL 2000...
> In PerfMon, I see Commited Bytes around 3.2 GB.
> In Task Manager I still see SQLServer.exe using 2.7 GB. I guess then
> that's just a problem related with Task Manager not showing the
> correct amount of RAM used...?
> Paul- Masquer le texte des messages prcdents -
> - Afficher le texte des messages prcdents -
When I say that I see 128 MB of RAM in SQLServer.exe when using AWE I
mean that's what I see in Task Manager. Am I correct looking at this
value?
Should I check PerfMon instead? Is the memory shown in TaskManager
only kernel memory and would not show all memory used by SQL?
Paul

8 GB of RAM

I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
Standard.
I have the switches /PAE /3GB in boot.ini
SQL max server memory is = 6656 MB
but with those settings I cannot get SQLServer to get more than 2.7 GB
of RAM
If I use the AWE switch, then SQLServer can only use 128 MB max
What's wrong?
PaulOn Dec 4, 3:42 am, pd...@.clic.net wrote:
> I am running Windows 2003 Enterprise with 8 GB of RAM and SQL Server
> Standard.
> I have the switches /PAE /3GB in boot.ini
> SQL max server memory is = 6656 MB
> but with those settings I cannot get SQLServer to get more than 2.7 GB
> of RAM
> If I use the AWE switch, then SQLServer can only use 128 MB max
> What's wrong?
> Paul
Is it SQL Server 2000 or SQL Server 2005?
If its SQL Server 2000, then AWE is not supported
If its SQL Server 2005, then check the AWE 'Run Value' in
sp_configure... if its 0, then you might want to recycle the SQL
Server service to enable the AWE
In any case i dont believe you need to have /3GB switch in boot.ini.|||Hey, of course you can use AWE on SQL Server 2000 (and also on SQL Server
2005).
You will need to run
sp_configure 'awe enabled', 1
and grant the Lock Page in Memory permission to your service account. For
more details see
How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"dineshbabu.munugala@.gmail.com" wrote:

> On Dec 4, 3:42 am, pd...@.clic.net wrote:
> Is it SQL Server 2000 or SQL Server 2005?
> If its SQL Server 2000, then AWE is not supported
> If its SQL Server 2005, then check the AWE 'Run Value' in
> sp_configure... if its 0, then you might want to recycle the SQL
> Server service to enable the AWE
> In any case i dont believe you need to have /3GB switch in boot.ini.
>|||Ben
If you are on 64-bit , you do not need AWE anymore. If the OP has SQL Server
2000 along with SP4 , make sure that he has a last hotfix especially if he
are going to enable AWE
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:2ADA35D9-C4FA-4852-B20A-3E08F240C626@.microsoft.com...[vbcol=seagreen]
> Hey, of course you can use AWE on SQL Server 2000 (and also on SQL Server
> 2005).
> You will need to run
> sp_configure 'awe enabled', 1
> and grant the Lock Page in Memory permission to your service account. For
> more details see
> How to configure SQL Server to use more than 2 GB of physical memory
> http://support.microsoft.com/kb/274750
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "dineshbabu.munugala@.gmail.com" wrote:
>|||On 3 d=E9c, 18:04, dineshbabu.munug...@.gmail.com wrote:
> On Dec 4, 3:42 am, pd...@.clic.net wrote:
>
>
>
>
>
>
> Is it SQL Server 2000 or SQL Server 2005?
> If its SQL Server 2000, then AWE is not supported
> If its SQL Server 2005, then check the AWE 'Run Value' in
> sp_configure... if its 0, then you might want to recycle the SQL
> Server service to enable the AWE
> In any case i dont believe you need to have /3GB switch in boot.ini.
SQL2005 Standard.
Running in 32 bits system
As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
(i.e. I run dbcc checkDB so that it starts using rapidly memory and I
see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
Paul|||Hi
Do you have SP4 with hotfix?
Install hotfix from(http://support.microsoft.com/kb/899761)
Do you see in PerfMon that SQL Server allocate 6.6GB RAM?
<pdube@.clic.net> wrote in message
news:e4a9b19a-1b95-4df7-b6d9-e8c374bfb9c0@.a39g2000pre.googlegroups.com...
On 3 dc, 18:04, dineshbabu.munug...@.gmail.com wrote:
> On Dec 4, 3:42 am, pd...@.clic.net wrote:
>
>
>
>
>
>
> Is it SQL Server 2000 or SQL Server 2005?
> If its SQL Server 2000, then AWE is not supported
> If its SQL Server 2005, then check the AWE 'Run Value' in
> sp_configure... if its 0, then you might want to recycle the SQL
> Server service to enable the AWE
> In any case i dont believe you need to have /3GB switch in boot.ini.
SQL2005 Standard.
Running in 32 bits system
As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
(i.e. I run dbcc checkDB so that it starts using rapidly memory and I
see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
Paul|||On 4 d=E9c, 10:45, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hi
> Do you have SP4 with hotfix?
> Install hotfix from(http://support.microsoft.com/kb/899761)
> Do you see in PerfMon that SQL Server allocate 6.6GB RAM?
> <pd...@.clic.net> wrote in message
> news:e4a9b19a-1b95-4df7-b6d9-e8c374bfb9c0@.a39g2000pre.googlegroups.com...
> On 3 d=E9c, 18:04, dineshbabu.munug...@.gmail.com wrote:
>
>
>
>
>
>
[vbcol=seagreen]
>
>
>
>
>
> SQL2005 Standard.
> Running in 32 bits system
> As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
> (i.e. I run dbcc checkDB so that it starts using rapidly memory and I
> see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
> Paul- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -
SQL 2005 (9.00.3161.00)
The hotfix is for SQL 2000...
In PerfMon, I see Commited Bytes around 3.2 GB.
In Task Manager I still see SQLServer.exe using 2.7 GB. I guess then
that's just a problem related with Task Manager not showing the
correct amount of RAM used...?
Paul|||On 4 d=E9c, 14:08, pd...@.clic.net wrote:
> On 4 d=E9c, 10:45, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
>
>
>
>
>
[vbcol=seagreen]
>
>
[vbcol=seagreen]
>
>
GB[vbcol=seagreen]
>
>
>
>
>
>
>
>
> SQL 2005 (9.00.3161.00)
> The hotfix is for SQL 2000...
> In PerfMon, I see Commited Bytes around 3.2 GB.
> In Task Manager I still see SQLServer.exe using 2.7 GB. I guess then
> that's just a problem related with Task Manager not showing the
> correct amount of RAM used...?
> Paul- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -
When I say that I see 128 MB of RAM in SQLServer.exe when using AWE I
mean that's what I see in Task Manager. Am I correct looking at this
value?
Should I check PerfMon instead? Is the memory shown in TaskManager
only kernel memory and would not show all memory used by SQL?
Paul|||SP4 hotfix is not needed here as this is SQL Server 2005.
Try this to see how much memory SQL Server is using. Performance Monitor,
add SQLServer:Memory Manager - Total Server Memory (KB).
Have you granted the Lock Page in Memory permission to your service account?
See your Error log. Must show 'Address Windowing Extensions enabled' or some
AWE error message.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Uri Dimant" wrote:

> Hi
> Do you have SP4 with hotfix?
> Install hotfix from(http://support.microsoft.com/kb/899761)
> Do you see in PerfMon that SQL Server allocate 6.6GB RAM?
>
>
> <pdube@.clic.net> wrote in message
> news:e4a9b19a-1b95-4df7-b6d9-e8c374bfb9c0@.a39g2000pre.googlegroups.com...
> On 3 déc, 18:04, dineshbabu.munug...@.gmail.com wrote:
> SQL2005 Standard.
> Running in 32 bits system
> As soon as I use AWE, I'm stuck with 128 MB of RAM for SQL server...
> (i.e. I run dbcc checkDB so that it starts using rapidly memory and I
> see SQLServer.exe using not more than 128 MB of RAM in Task Manager).
> Paul
>
>|||Sorry. I missed that you are on SQL Server 2005.
In 32 -bit you do need AWE and as Ben pointed out gran permission Lock
Page in Memory permission to your service account.
To see if SQL server uses 6GB open PerfMonitor , do not use Task Manager
Visit also http://blogs.msdn.com/slavao/
<pdube@.clic.net> wrote in message
news:f9c9559b-d836-4b7f-92d4-bfc8834aab35@.s36g2000prg.googlegroups.com...
On 4 dc, 14:08, pd...@.clic.net wrote:
> On 4 dc, 10:45, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> SQL 2005 (9.00.3161.00)
> The hotfix is for SQL 2000...
> In PerfMon, I see Commited Bytes around 3.2 GB.
> In Task Manager I still see SQLServer.exe using 2.7 GB. I guess then
> that's just a problem related with Task Manager not showing the
> correct amount of RAM used...?
> Paul- Masquer le texte des messages prcdents -
> - Afficher le texte des messages prcdents -
When I say that I see 128 MB of RAM in SQLServer.exe when using AWE I
mean that's what I see in Task Manager. Am I correct looking at this
value?
Should I check PerfMon instead? Is the memory shown in TaskManager
only kernel memory and would not show all memory used by SQL?
Paul

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