Memory Usage

Hello Everybody,
We have a SQL SERVER installed on a Windows 2003 SERVER which has memory of
3.5 GB. We have configured SQL SERVER as a Dynamically Configure SQL SERVER
memory when we installed. Now when we check memory usage of SQL SERVER
sqlservr.exe is using a 1.7 GB of memory ? os just wondering is it normal ?
Pls let us know.Which version of sql server 2000 do you have?. If it is standard, then it ca
n
use 2gbytes max, if it is enterprise, then you have to configure the server
in order to sql server use more than 2gb.
How to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/kb/274750/
AMB
"mvp" wrote:

> Hello Everybody,
> We have a SQL SERVER installed on a Windows 2003 SERVER which has memory o
f
> 3.5 GB. We have configured SQL SERVER as a Dynamically Configure SQL SERVE
R
> memory when we installed. Now when we check memory usage of SQL SERVER
> sqlservr.exe is using a 1.7 GB of memory ? os just wondering is it normal
?
> Pls let us know.|||mvp wrote:
> Hello Everybody,
> We have a SQL SERVER installed on a Windows 2003 SERVER which has
> memory of
> 3.5 GB. We have configured SQL SERVER as a Dynamically Configure SQL
> SERVER memory when we installed. Now when we check memory usage of
> SQL SERVER sqlservr.exe is using a 1.7 GB of memory ? os just
> wondering is it normal ?
> Pls let us know.
Are you wondering why it's using 1.7GB or why it's not using more? SQL
Server does not release memory back to the OS once it claims it, except
under certain server conditions. If you want SQL Server to not use more
than a specified amount of memory, you can set an upper memory limit.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||> We have a SQL SERVER installed on a Windows 2003 SERVER which has memory
> of
> 3.5 GB. We have configured SQL SERVER as a Dynamically Configure SQL
> SERVER
> memory when we installed. Now when we check memory usage of SQL SERVER
> sqlservr.exe is using a 1.7 GB of memory ? os just wondering is it normal
> ?
Sure, you have it set to take the memory it needs, and so far it has only
needed 1.7 GB. If you want to start it higher, you can do so...