Missing RAM

My server has Windows 2000 Advanced Server as the operating system with 4GB
of RAM and SQL Server 2000 as the database server. In perfmon the SQL Serve
r
target server memory and SQL Server total server memory list at 1.68 GB.
What could be reducing the memory to 1.68 GB. How can I resolve this issue.
Thank You,What edition of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with 4G
B
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL Ser
ver
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this issu
e.
> Thank You,|||Joe,
Check the memory setting (esp the max memory) for the SQL Server. In EM
right click the SQL Server -->Properties--> Memory.
HTH
Jerry
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with
> 4GB
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL
> Server
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this
> issue.
> Thank You,