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