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 SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-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 SQLMonster.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 SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-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 SQLMonster.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 SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200707/1
>