memory allocation

Why a server would only allocate 100k to SQL Server when it's given 4gb. The
sqlserver box has a 2 processor / 4gb RAM server. The sqlserver.exe process
is only using 100-200k and not growing. The CPU is pegged at 90-100% during
peak hours. It is SQL Server 2000 Enterprise Ed. with /GB /PAE switches in
the BOOT.INI and AWE enabled.
Thanks in advance
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200707/1My guess is that you are looking in task manager which isn't PAE/AWE aware.
Use Perfmon instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"vision via droptable.com" <u22707@.uwe> wrote in message news:75bb9a16fd86d@.uwe...agreen">
> Why a server would only allocate 100k to SQL Server when it's given 4gb. T
he
> sqlserver box has a 2 processor / 4gb RAM server. The sqlserver.exe proces
s
> is only using 100-200k and not growing. The CPU is pegged at 90-100% durin
g
> peak hours. It is SQL Server 2000 Enterprise Ed. with /GB /PAE switches i
n
> the BOOT.INI and AWE enabled.
> Thanks in advance
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200707/1
>|||Well with only 4GB of memory you should not be using AWE or PAE. If you
didn't set a max memory setting you will starve the OS of memory. Turn those
off and with the /3GB you should have 3GB allocated to SQL Server and leave
plenty for the OS an other apps.
Andrew J. Kelly SQL MVP
"vision via droptable.com" <u22707@.uwe> wrote in message
news:75bb9a16fd86d@.uwe...
> Why a server would only allocate 100k to SQL Server when it's given 4gb.
> The
> sqlserver box has a 2 processor / 4gb RAM server. The sqlserver.exe
> process
> is only using 100-200k and not growing. The CPU is pegged at 90-100%
> during
> peak hours. It is SQL Server 2000 Enterprise Ed. with /GB /PAE switches
> in
> the BOOT.INI and AWE enabled.
> Thanks in advance
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200707/1
>|||I have a similar setup where I have a 32-bit Win2k3 sp1 server with 4 GB
RAM, 4 processors and SQL 2005 sp2 (build 3161) installed.
If I have max memory set to 3 gb, does it hurt if I have 'lock pages in
memory' and the /3gb switch set?
Looking at sp_configure, it isn't using AWE even after enabling it,
running reconfigure, and rebooting. Is that ok?
Thank you,
Toni
*** Sent via Developersdex http://www.codecomments.com ***|||> If I have max memory set to 3 gb, does it hurt if I have 'lock pages in
> memory' and the /3gb switch set?
Its not necessary to have lock pages set but I don't believe it hurts.

> Looking at sp_configure, it isn't using AWE even after enabling it,
> running reconfigure, and rebooting. Is that ok?
AWE is not valid with only 3GB so SQL Server is ignoring it.
Andrew J. Kelly SQL MVP
"Toni" <teibner@.allinadotcom> wrote in message
news:ujr9WWP2HHA.748@.TK2MSFTNGP04.phx.gbl...
>I have a similar setup where I have a 32-bit Win2k3 sp1 server with 4 GB
> RAM, 4 processors and SQL 2005 sp2 (build 3161) installed.
> If I have max memory set to 3 gb, does it hurt if I have 'lock pages in
> memory' and the /3gb switch set?
> Looking at sp_configure, it isn't using AWE even after enabling it,
> running reconfigure, and rebooting. Is that ok?
> Thank you,
> Toni
> *** Sent via Developersdex http://www.codecomments.com ***